adoQToday.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime>='''+tdatetime+'''');
行吗?
...全文
29329打赏收藏
adoQuery的问题!急!急!急!急!急!
如何过滤出当天的记录。 谢谢! var tdatetime:string; adoQToday.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime>='''+tdatetime+''''); 行吗?
如何加上时间的限制 adoquery.sql.add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where [dodatetime] between #'+FormatDateTime('yyyy-mm-dd',now)+'00:00:00'+'# and #'+FormatDateTime('yyyy-mm-dd',now)+' 23:59:59#');
有错谁帮我改改。谢谢了。
adoQToday.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime between '''+tdatetime+''' and '''+tdatetime +1+'''');
个人感觉象jiaai(逍遥游)这样的方法好点。但是运行时提示错误!有人能解决吗?谢谢了!
adoquery.sql.add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where [dodatetime] between #'+FormatDateTime('yyyy-mm-dd',now)+'00:00:00'+'# and #'+FormatDateTime('yyyy-mm-dd',now)+' 23:59:59#');
它运行时提示不正常定义的参数对象。
tdatetime:= FormatDateTime('yyyy-mm-dd',now);
tmpSql:='select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime='+''''+tdatetime+'''';
adoQToday.SQL.Add(tmpSql);
jiaai(逍遥游)
adoquery.sql.add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where [dodatetime] between #'+FormatDateTime('yyyy-mm-dd',now)+'00:00:00'+'# and #'+FormatDateTime('yyyy-mm-dd',now)+' 23:59:59#');
它运行时提示不正常定义的参数对象。
>>adoQToday.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts >>where dodatetime>='''+tdatetime+'''');
你最好表“accounts”的字段“dodatetime”保存的值最好是“yyyy-mm-dd"的
如:”2004-11-18“
然后你SQL可写成
select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime=FormatDateTime('yyyy-mm-dd',now)
试试,看行不行
adoquery.sql.add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where [dodatetime] between #'+FormatDateTime('yyyy-mm-dd',now)+'00:00:00'+'# and #'+FormatDateTime('yyyy-mm-dd',now)+' 23:59:59#');
adoQToday1.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts');
if (strtodatetime(adoquery1.FieldValues['dodatetime'])=strtodatetime(formatdatetime('yyyy-m-d',now))) then
begin
//....
end;
adoQToday.SQL.Add('select rdn,inkind,cash,dodatetime,indatetime,opemp from accounts where dodatetime=:RQ');
adoQToday.Parameters[0].datatype:=ftDateTime;
adoQToday.Parameters[0].value:=Date;
adoQToday.Prepared:=True;
adoQToday.Open;