With Adoquery1 Do
Begin
If Acitve Then Close;
Sql.Clear;
Sql.Add(''select * from aaa where name=:name');
Parameters[0].Value:=Edit1.Text;
If Not Prepared Then Prepared;
Open;
End;
var
s:string
begin
s:=edit1.text;
adoquery1.active:=false;
adoquery1.sql.clear;
adoquery1.sql.add('select * from aaa where name=:s');
adoquery1.parameters.parambyname('s')=s;
adoquery1.active:=true;
end;
试试看,
应该是
var
s:string
begin
s:=edit1.text;
adoquery1.sql.text:='select * from aaa where name=:s';
adoquery1.parameters.parambyname('s').value:=s;
adoquery1.open;
...
end;
推荐你还是用参数吧,用参数感觉比较好,绝对准确
var
s:string
begin
s:=edit1.text;
adoquery1.sql.clear;
adoquery1.sql.add('select * from aaa where name=:lsname');
adoquery1.parameters.parambyname('lsname').value:=s
adoquery1.open;
end;
各位前辈,我写的下面几行老出错:
var
s:string
begin
s:=edit1.text;
adoquery1.sql.text:='select * from aaa where name=:s';
adoquery1.parambyname('s').value:=s;
adoquery1.open;
...
end;