SQL.ADD('SELECT * FROM Sample WHERE Date<:vDate'); SQL.ParamByName('vDate').AsDate:=now;
with Qry_Sample do begin close; SQL.clear; Sql.add('select * frm sample where pData<:pData'); Parambyname('pData').asdatetime:=date-n(表示n天); Open; end;
似乎还是有问题,如果用到 like '%:vdata%' 时老是提示vdate这个参数没有发现。select * from table where address like ''%:vaddress%'' query1.ParamByName('vaddress').asstring:=address; query1.Open;
SQL.ParamByName('vDate').AsDate:=now;
begin
close;
SQL.clear;
Sql.add('select * frm sample where pData<:pData');
Parambyname('pData').asdatetime:=date-n(表示n天);
Open;
end;
query1.ParamByName('vaddress').asstring:=address;
query1.Open;