我是个新手,请问 如果 有个datetimepicker控件,我在sql中这样表示
flpzquery1.close;
flpzquery1.sql.clear;
flpzquery1.sql.add('select * from flpz ');
flpzquery1.SQL.Add('where flrq='''+Datetimepicker1.date+'''');
flpzquery1.sql.open;
运行时 出现这个错误
[Error] flcx.pas(68): Incompatible types: 'String' and 'TDate'
请问怎样解决,谢谢啦
flpzquery1.close;
flpzquery1.sql.clear;
flpzquery1.sql.add('select * from flpz ');
flpzquery1.SQL.Add('where flrq='''+Datetimepicker1.date+'''');
flpzquery1.sql.open;
运行时 出现这个错误
[Error] flcx.pas(68): Incompatible types: 'String' and 'TDate'
请问怎样解决,谢谢啦
flpzquery1.sql.clear;
flpzquery1.sql.add('select * from flpz ');
// flpzquery1.SQL.Add('where flrq='''+Datetimepicker1.date+'''');
flpzquery1.SQl.Add('where flrq='''+datetostr(datetimepicker1.date)+'''');
flpzquery1.sql.open;
datetostr只是把其转换成字符型了,请问怎么解决
flpzquery1.sql.clear;
flpzquery1.sql.add('select * from flpz ');
flpzquery1.SQL.Add('where flrq='''+Datetimepicker1.date+'''');
flpzquery1.SQl.Add('where flrq='''+DateTimeToStr(datetimepicker1.date)+'''');
flpzquery1.sql.open;
flpzquery1.close;
flpzquery1.sql.clear;
flpzquery1.sql.add('select * from flpz ');
flpzquery1.SQL.Add('where flrq=:date);
flpzquery1.parambyname('date').AsDate:=Datetimepicker1.date;
flpzquery1.sql.open;