thank you very much! 我成功啦,象颜羽说的: SQL->Add("where fee.Pay_date > :mTime "); Query->ParamByName("mTime")->AsDate=datetimepicker1.datetime; to akademecia 你就照此做吧!!!
close; sql.Clear; sql.Add('insert into fee_temp '); sql.Add('select * from fee where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)'); parameters[0].Value:=timestart; parameters[1].Value:=timeend; execsql;
'where 维修记录.时间 =' + ''' + datetostr(1999-1-21) + ''''
我的表中‘时间‘是date(paradox数据库)类型的
为什么??
错误为:mismatch data type
'where fee.Pay_date>='''+datetimetostr(datetimepicker1.datetime)+''''
------------------------------------------------------------------
不对吧,老兄
paradox数据库中的date类型数据你能做出来吗??
Query->ParamByName("mTime")->AsDate=datetimepicker1.datetime;
一样的:
query1.add('where 维修记录.时间 ='+datetostr(1999-01-21) +'');
你试一下。
还是出错
'where 维修记录.时间 ='+datetostr(1999-01-21)+''
sql.add('select * from fee ');
试试
我成功啦,象颜羽说的:
SQL->Add("where fee.Pay_date > :mTime ");
Query->ParamByName("mTime")->AsDate=datetimepicker1.datetime;
to akademecia
你就照此做吧!!!
sql.Clear;
sql.Add('insert into fee_temp ');
sql.Add('select * from fee where (Pay_Is=true) and (Pay_Acman='''+op+''') and (Pay_Date>=:ss) and (Pay_Date<=:ee)');
parameters[0].Value:=timestart;
parameters[1].Value:=timeend;
execsql;