with adoquery1 do begin close; clear; sql.add('select * from table where f1 like '+#39+'%'+ edit1.Text+'%'''); Open; end;
with adoquery1 do begin close; clear; sql.add('select * from table where f1 like ''A'''); Open; end;
错了,应该是: with adoquery1 do begin close; clear; sql.add('select * from table where f1 like ''%A%'''); Open; end;
with adoquery1 do begin close; clear; SQL.Add('select * from tmp where field1 like :field1'); Parameters.ParamByName('field1').Value := '%'+str+'%'; try Open; except showmessage('error'); end; end;
1.ADOQuery.Filter:='字段名=''A'''; ADOQuery.Filtered:=True; 可以利用ADOQuery.FindNext等上下移动; 2. with adoquery1 do begin Close; SQL.Clear; SQL.Add('select * from tmp where field1 like ''%a%'''); try Open; except showmessage('error'); end; end;
你的是那个数据库啊,以后问题明确点。
begin
close;
clear;
sql.add('select * from table where f1 like '+#39+'%'+ edit1.Text+'%''');
Open;
end;
begin
close;
clear;
sql.add('select * from table where f1 like ''A''');
Open;
end;
with adoquery1 do
begin
close;
clear;
sql.add('select * from table where f1 like ''%A%''');
Open;
end;
begin
close;
clear;
SQL.Add('select * from tmp where field1 like :field1');
Parameters.ParamByName('field1').Value := '%'+str+'%';
try
Open;
except
showmessage('error');
end;
end;
ADOQuery.Filtered:=True;
可以利用ADOQuery.FindNext等上下移动;
2.
with adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from tmp where field1 like ''%a%''');
try
Open;
except
showmessage('error');
end;
end;
No.1:于BDE的一样。
No.2:楼上的都说了啊。