求助～～这句sql在access中直接运行可以，但是在delphi中执行出错

[a9]

select H.holderno,H.holdername,IODate, maxtime, mintime from HolderData as H Left outer join (select HolderNo,IODate,max(IOTime) as maxTime,min(IOTime) as minTime from IOData where IODate between #2004-10-20# and #2004-10-29# group by HolderNo,IOdate ) as T on T.holderno=H.holderno

在access中直接运行正常，但是在delphi中运行提示，adoquery1:field'cardno' not found
奇怪，我并没有取库里面的这个字段啊。

jet连接不行，换成odbc也是一样的问题。

[a9]

寒自己一下

楼上的说对了

结贴～～

[hxdosa]

呵呵 顶一下

[gxgyj]

clear

[a9]

ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add ('Select H.holderno,H.holdername,IODate, maxtime, mintime from HolderData as H ');
ADOQuery1.SQL.Add (' Left outer join (select HolderNo,IODate,max(IOTime) as maxTime,min(IOTime) as minTime from IOData where IODate between #2004-10-20# and #2004-10-29# group by HolderNo,IOdate ) as T on T.holderno=H.holderno');
//showmessage(adoquery1.SQL.Text);
ADOQuery1.Open;

不是楼上说的问题

[coolnan]

where IODate between #2004-10-20# and #2004-10-29#

IODate是什么类型的？

[zzlazio]

是不是ADOQUERY1里面自己添加了cardno字段啊

[angle097113]

adoquery1:field'cardno' not found
是不是你在数据集中的永久字段添加这个字段了啊，而你选择的时候没有选取这个字段啊