ADOConnection1.Execute('select * into 5 from T_His_Veh_Traffic IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=研发数据服务器;DataBase=RCH] where Collect_Time>=:RQ1 and Collect_Time<=:RQ2'); end;这个是什么意思?
ADOConnection1.Execute('select * into [5] from T_His_Veh_Traffic IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=研发数据服务器;DataBase=RCH] where Collect_Time>='''+变量1+''' and Collect_Time<='''+变量2+'''');
to:pengdali(大力 V3.0)
您说的还是不行啊 编译提示[Error] Unit1.pas(37): Incompatible types: 'String' and 'TDate'怎么回事?
to:pengdali(大力 V3.0)
您说的还是不行啊 编译提示[Error] Unit1.pas(37): Incompatible types: 'String' and 'TDate'怎么回事?
那个Datetime类型的赋值有问题 怎么该啊?
试试先把RQ1 ,RQ2转换成字符串型,再把 Collect_Time>=:RQ1 and Collect_Time<=:RQ2' 改为: Collect_Time>='''+:RQ1+''' and Collect_Time<='''+:RQ2+''''
您说的还是不行啊 编译提示[Error] Unit1.pas(37): Incompatible types: 'String' and 'TDate'怎么回事?
您说的还是不行啊 编译提示[Error] Unit1.pas(37): Incompatible types: 'String' and 'TDate'怎么回事?
Collect_Time>=:RQ1 and Collect_Time<=:RQ2'
改为:
Collect_Time>='''+:RQ1+''' and Collect_Time<='''+:RQ2+''''