表main里有一个Tdatetime字段,为了查找该字段里日期小于当前输入日期的记录,我在按钮后写了如下代码:
var
datenow: Tdatetime;
begin
datenow:=datetimepicker1.Datetime;
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from main where 计划检定日期<searchdate');
unprepare;
parambyname('searchdate').AsDatetime:=datenow;
prepare;
open;
end;
end;但是运行不能通过,错误信息“Query1:未发现参数'searchdate”
searchdate不是用parambyname('searchdate').AsDatetime:=datenow;定义过了吗?请高手指教?谢谢!
var
datenow: Tdatetime;
begin
datenow:=datetimepicker1.Datetime;
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from main where 计划检定日期<searchdate');
unprepare;
parambyname('searchdate').AsDatetime:=datenow;
prepare;
open;
end;
end;但是运行不能通过,错误信息“Query1:未发现参数'searchdate”
searchdate不是用parambyname('searchdate').AsDatetime:=datenow;定义过了吗?请高手指教?谢谢!
datenow: Tdatetime;
begin
datenow:=datetimepicker1.Datetime;
with query1 do
begin
close;
sql.Clear;
sql.Add('select * from main where 计划检定日期<:searchdate');
--注意是:searchdate
unprepare;
parambyname('searchdate').AsDatetime:=datenow;
prepare;
open;
end;
end;