说清楚点!是用在SQL语句的查询中吗? var aSQL: string; id: integer; begin aSQL := Format(' select * from tablename where Id = %d', [id]); ... end;
Query1.SQL.Clear; Query1.SQL.Add('select * from Table'); Query1.SQL.Add('where Id=:id'); Query1.ParamByName('id').AsString:=Edit1.Text;
with adoquery1 do begin close; sql.clear; add('select * from tablename'); add(' where id=:id'); parameters.parambyname('id').value := edit1.text open; end;
var change:string; begin change:=edit1.text; Query1.close; Query1.SQL.Clear; Query1.SQL.Add('select * from Table where 字段名 like''+change+'''); query1.open; end;
var
aSQL: string;
id: integer;
begin
aSQL := Format(' select * from tablename where Id = %d', [id]);
...
end;
Query1.SQL.Add('select * from Table');
Query1.SQL.Add('where Id=:id');
Query1.ParamByName('id').AsString:=Edit1.Text;
begin
close;
sql.clear;
add('select * from tablename');
add(' where id=:id');
parameters.parambyname('id').value := edit1.text
open;
end;
change:string;
begin
change:=edit1.text;
Query1.close;
Query1.SQL.Clear;
Query1.SQL.Add('select * from Table where 字段名 like''+change+''');
query1.open;
end;