D
dianjiwuxian
Unregistered / Unconfirmed
GUEST, unregistred user!
请看以下代码:
with mydata.ADOQuery4 do
begin
close;
sql.text:='select * from (mydata_xiaoshou xiaoshou inner join mydata_spxx spxx on xiaoshou.商品id=spxx.id ) inner join mydata_scmc scmc on xiaoshou.柜台id=scmc.id where xiaoshou.销售时间 between :aa and :bb ';
parameters.ParamByName('aa').Value:=datetimepicker1.Date;
parameters.ParamByName('bb').Value:=datetimepicker2.Date;
open;
我想查询在datetimepicker1,2之间的记录。怎么查询不到。为什么?
with mydata.ADOQuery4 do
begin
close;
sql.text:='select * from (mydata_xiaoshou xiaoshou inner join mydata_spxx spxx on xiaoshou.商品id=spxx.id ) inner join mydata_scmc scmc on xiaoshou.柜台id=scmc.id where xiaoshou.销售时间 between :aa and :bb ';
parameters.ParamByName('aa').Value:=datetimepicker1.Date;
parameters.ParamByName('bb').Value:=datetimepicker2.Date;
open;
我想查询在datetimepicker1,2之间的记录。怎么查询不到。为什么?