Question

delphi sql 里，这语句应该怎么写？数字变量传入

Query1.SQL.Add('and Year(A.StartTime)='+StrtoInt(formatdatetime('yyyy',DateTimePicker1.Date))');

这个是出错的。

Answer 1

Query1.SQL.Add('and Year(A.StartTime)=:startTime');
Query1.Parameters.ParamByName('startTime').Value:=
StrtoInt(formatdatetime('yyyy',DateTimePicker1.Date));

Answer 2

不用转int，直接用字符串就行。

Query1.SQL.Add('and Year(A.StartTime)='+quotedstr(formatdatetime('yyyy',DateTimePicker1.Date)));