if (trim(Edt_data_Beg.Text)<>'') and (trim(Edt_data_end.Text)='') then
begin
// Beg_time:=strToDate(Edt_data_Beg.Text);
seekWhat:='and STR_DD > ''#trim(Edt_data_Beg.Text)# '' '; //??
end
else
seekWhat:='';
----------------------------------
ADODataSet_tf_card.CommandText:=
'select * from TF_CARD'+' '+list_or_not+' '+seekWhat+' '+'order by '+orderby_what+' '+' ASC ';其中STR_DD为Datetime字段
关键是 seekWhat:='and STR_DD > ''#trim(Edt_data_Beg.Text)# '' ';
如何写!
begin
// Beg_time:=strToDate(Edt_data_Beg.Text);
seekWhat:='and STR_DD > ''#trim(Edt_data_Beg.Text)# '' '; //??
end
else
seekWhat:='';
----------------------------------
ADODataSet_tf_card.CommandText:=
'select * from TF_CARD'+' '+list_or_not+' '+seekWhat+' '+'order by '+orderby_what+' '+' ASC ';其中STR_DD为Datetime字段
关键是 seekWhat:='and STR_DD > ''#trim(Edt_data_Beg.Text)# '' ';
如何写!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货