帮忙看看!小弟刚学

Question

var
s2,s3,t,string;
with datamodule3 do
begin 
s2:=datetostr(datetimepicker9.date);
s3:='select 成交日期 from bargain where 成交日期>'+s2;
bargaiprintquery.close;
bargaiprintquery.sql.clear;
bargaiprintquery.add(s3);
bargaiprintquery.open;
t:=datetostr(bargaiprintquery['成交日期']);//加上这句报错
end;
报错提示:----invalid variart type conversion
各位帮忙改改

Answer 1

t:=datetostr(bargaiprintquery['成交日期']);//加上这句报错
改为:
t:=datetostr(bargaiprintquery.FieldbyName('成交日期').AsDateTime);