zch:='select * from from piece_history where 日期时间 between ' + #39 + DateToStr(DateTimePicker1.Date) + ' ' + timetostr(datetimepicker3.Time) + #39 + ' and ' + #39 + DateToStr(DateTimePicker2.Date) + ' ' + timetostr(datetimepicker4.Time) + #39 +' and 钢种='''+trim(combobox1.Text)+'''';
查询后提示:
Project pjtmasteel.exe raise exception class EDatabaseError with message 'adoqryzch:Commandtext dose not return a result set'
查询后提示:
Project pjtmasteel.exe raise exception class EDatabaseError with message 'adoqryzch:Commandtext dose not return a result set'
查询后提示:
Project pjtmasteel.exe raise exception class EDatabaseError with message 'adoqryzch:Commandtext dose not return a result set'这个里面好像 多个from 'select * form piece_history...' 日期时间 用一句 估计 你这个 时间 可能这样写容易出问题 str1:=formatdatetime('yyyy-MM-DD',datetimepicker1.date)+' '+formatdatetime('HH:nn:ss',datetimepicker2.time);
str2:=formatdatetime('yyyy-MM-DD',datetimepicker1.date)+' '+formatdatetime('HH:nn:ss',datetimepicker2.time); 上面的语句 在 ...where 日期时间>=str1 and 日期时间<=str2
查询后提示:
Project pjtmasteel.exe raise exception class EDatabaseError with message 'adoqryzch:Commandtext dose not return a result set'这个里面好像 多个from 'select * form piece_history...' 日期时间 用一句 估计 你这个 时间 可能这样写容易出问题 str1:=formatdatetime('yyyy-MM-DD',datetimepicker1.date)+' '+formatdatetime('HH:nn:ss',datetimepicker2.time);
str2:=formatdatetime('yyyy-MM-DD',datetimepicker1.date)+' '+formatdatetime('HH:nn:ss',datetimepicker2.time); 上面的语句 在 ...where 日期时间>=str1 and 日期时间<=str2
zch:='select * from from piece_history where 日期时间 between ' + #39 + DateToStr(DateTimePicker1.Date) + ' ' + timetostr(datetimepicker3.Time) + #39 + ' and ' + #39 + DateToStr(DateTimePicker2.Date) + ' ' + timetostr(datetimepicker4.Time) + #39 +' and 钢种='''+trim(combobox1.Text)+'''';
能给出除SQL语句外的其他代码吗?
zch:='select * from piece_history where 日期时间 between ' + #39 + DateToStr(DateTimePicker1.Date) + ' ' + timetostr(datetimepicker3.Time) + #39 + ' and ' + #39 + DateToStr(DateTimePicker2.Date) + ' ' + timetostr(datetimepicker4.Time) + #39 +' and 钢种='''+trim(combobox1.Text)+'''';
with adoqryzch do
begin
close;
sql.Clear;
sql.Add(zch);
open; end;
看是不是 日期格式转化的问题
看看adoqryzch 对象是Tadoquery类的实例化对象吗!