想写:select * from mtype where fid= 一个整型变量var
ii : integer;
begin
form2.ADOQuery2.SQL.Add('select * from mtype');
form2.ADOQuery2.SQL.Add('where fid=');
form2.ADOQuery2.SQL.Add('''+ii+''');
......
ii : integer;
begin
form2.ADOQuery2.SQL.Add('select * from mtype');
form2.ADOQuery2.SQL.Add('where fid=');
form2.ADOQuery2.SQL.Add('''+ii+''');
......
form2.ADOQuery1.Open;
form2.ADOQuery1.First;
maxid:= ????????????????
form2.ADOQuery1.Open;
form2.ADOQuery1.First;
maxid:=ADOQuery1.FieldByName("jinjazz").AsInteger;
看来ADOQuery 没有什么方法/属性能办到了?
ADOQuery1.SQL.clear;
ADOQuery1.SQL.add('select * from table where id=:id_p');
ADOQuery1.Parameters.ParamByName('id_p'):= Edt_id.text;
ADOQuery1.open;