错误提示:类型不匹配,不知错在哪了
query1.SQL.Add('select * from 拆迁人资料表.db where 时间 '+' = '+''''+trim(datetostr(datetimepicker1.Datetime))+'''');
query1.SQL.Add('select * from 拆迁人资料表.db where 时间 '+' = '+''''+trim(datetostr(datetimepicker1.Datetime))+'''');
调试欢乐多
Query1.SQL.Add('select * from select * from 拆迁人资料表.db where 时间=:time');
Query1.ParamByName('time').AsString:=DateToStr(Datetimepicker1.Datetime);如果不可以的话,可能你的“时间”字段不是字符串类型的。把上句改为:
Query1.ParamByName('time').AsDateTime:=Datetimepicker1.Datetime;
就是可以的了吧