如果改成Add('FROM mytable where xingqi="week"');就能查到,但是用参数就不行。怪了,我已经照书上写了,怎么不行
应该不行了,因为你先给出了参数,再给sql语句,好象不性 with ADOQuery1 do begin close; with SQL do begin Clear; Add('SELECT * '); Add('FROM mytable where xingqi=:weekday'); end; //with SQL do begin Parameters.ParamByName('weekday').Value := 'week'; Open; end; //with ADOQuery1 do begin end; 你这样试试看
with ADOQuery1 do begin
close;
with SQL do begin
Clear;
Add('SELECT * ');
Add('FROM mytable where xingqi=:weekday'); end; //with SQL do begin
Parameters.ParamByName('weekday').Value := 'week';
Open;
end; //with ADOQuery1 do begin
end;
你这样试试看