现在我要查找某个时间段的记录进行查询,时间来自DateTimePicker1,请问如何写。
语句在SQL中能够执行,但是在delphi中不能执行。
//=========================================
ADOQry_Grid.SQL.Add('and a.shijiaorq between '''+DateToStr(DateTimePicker1.Date)+''' and '''+DateToStr(DateTimePicker1.Date)+'' );
//========================================
语句在SQL中能够执行,但是在delphi中不能执行。
//=========================================
ADOQry_Grid.SQL.Add('and a.shijiaorq between '''+DateToStr(DateTimePicker1.Date)+''' and '''+DateToStr(DateTimePicker1.Date)+'' );
//========================================
ADOQry_Grid.SQL.Add('and a.shijiaorq between*'+DateToStr(DateTimePicker1.Date)+'*and *'+DateToStr(DateTimePicker1.Date));
注:"*"处代表空格,不要用''表示,很容易错的.
ADOQry_Grid.SQL.Add('and a.bencirq<='''+formatdatetime('yyyy-mm-dd',datetimepicker2.Date)+'');
//============
上面的怎么样???
adoquery1.sql.aDD('where shijianrq>=:Aa1 and shijianrq<=:Aa2');
adoquery1.Parameters.ParamByName('Aa1').ASdateTime:=DateTimePicker1.Date;
adoquery1.Parameters.ParamByName('Aa1').ASdateTime:=DateTimePicker2.Date;
adoquery1.Open;
adoquery1.sql.aDD('where 时间1>=:data1 and 时间2<=:data2');
adoquery1.Parameters.ParamByName('data1').ASdateTime:=DateTimePicker1.Date;
adoquery1.Parameters.ParamByName('data2').ASdateTime:=DateTimePicker2.Date;
adoquery1.Open;
但是出错
//===================
[Error] Unit1.pas(39): Undeclared identifier: 'ASdateTime'
//===================
请问为什么?
adoquery1.SQL.Add('select * from 表名');
adoquery1.sql.aDD('where 时间1>=:data1 and 时间2<=:data2');
adoquery1.Parameters.ParamByName('data1'):=DateTimePicker1.Date;
adoquery1.Parameters.ParamByName('data2'):=DateTimePicker2.Date;
adoquery1.active:=true;
这样就差不多了,试试看
adoquery1.SQL.Add('select * from 表名');
adoquery1.sql.aDD('where 时间1>=:data1 and 时间2<=:data2');
adoquery1.Parameters.ParamByName('data1'):=DateTimePicker1.Date;
adoquery1.Parameters.ParamByName('data2'):=DateTimePicker2.Date;
adoquery1.active:=true
===========================
将
adoquery1.Parameters.ParamByName('data1'):=DateTimePicker1.Date;adoquery1.Parameters.ParamByName('data2'):=DateTimePicker2.Date;
中的DateTimePicker1.Date改为datatostr(DateTimePicker1.Date)
我也是正在查相关的资料,刚刚看到的答案,正在试。回头试好了,再联系
..
有本事的进下面这个问题;
http://expert.csdn.net/Expert/topic/2288/2288203.xml?temp=.2813227