showmessage(inttostr(mynum));//这一个是我想知道能不能得倒值,没有用。Adoquery1.sql.add('select * from news where test=1')会成功的!可
ADoquery1.sql.add('select * from news where test=:mynum')
则不得行。!
ADoquery1.sql.add('select * from news where test=:mynum')
则不得行。!
var
mynum:integer;
begin
try
mynum:=strtoint(Edit1.text);
except
application.messagebox('发生错误 ,在输入中','发生错误',mb_ok);
exit;
end;
ADoquery1.Close;
Adoquery1.SQL.Clear;
showmessage(inttostr(mynum));
Adoquery1.SQL.add('select * from news where test=:mynum');
//加上此句
adoquery1.Parameters[0].Value :=mynum; end;
ADoquery1.Open;end;end.
Adoquery1.SQL.Clear;
showmessage(inttostr(mynum));
Adoquery1.SQL.add('select * from news where test=:mynum');
Adoquery1.Parameters[0].Value :=mynum;//在此赋值
ADoquery1.Open;
begin
close;
sql.clear;
sql.add(……);
Parameters[0].Value:=值;
Open;
end;