sql.add('select * from 表 where datetime字段 between '+datestring1+' and '+datestring2)
还是不行啊 说是什么datestring没定义? 还是什么不匹配的....
贴出你的SQL语句看看.SQL.text:=Format('select * from 表 where 字段 between %s and %s', [QuotedStr(FormatDateTime('yyyy-mm-dd hh:nn:ss',datetimepicker1.DateTime)), QuotedStr(FormatDateTime('yyyy-mm-dd hh:nn:ss',datetimepicker1.DateTime))]);
query.text:='select * from 表 where datetime字段 between :d1 and :d2'; query.Parameters.ParamByName( 'd1').Value:=DateTimePicker1.datetime; query.Parameters.ParamByName( 'd2').Value:=DateTimePicker2.datetime;
用SQL怎么弄在Button里面写啊
我弄的老出错....
说是什么datestring没定义?
还是什么不匹配的....
[QuotedStr(FormatDateTime('yyyy-mm-dd hh:nn:ss',datetimepicker1.DateTime)),
QuotedStr(FormatDateTime('yyyy-mm-dd hh:nn:ss',datetimepicker1.DateTime))]);
query.Parameters.ParamByName( 'd1').Value:=DateTimePicker1.datetime;
query.Parameters.ParamByName( 'd2').Value:=DateTimePicker2.datetime;