查询 adoquery.sql.text:='select * from yourtablename where field='''+变量名+''''; adoquery.open; 修改: adoquery.sql.text:='update yourtablename set field='''+变量名+''' where field='''+变量名+''''; adoquery.execsql;
你也可能创建变量啊 adoquery1:=TADOQuery.Create(self); adoquery1.Connection:=ADOConnection1; adoquery1.SQL.Text:='select * from tablename; adoquery1.Open;
adoquery.sql.text:='select * from yourtablename where field='''+变量名+'''';
adoquery.open;
修改:
adoquery.sql.text:='update yourtablename set field='''+变量名+''' where field='''+变量名+'''';
adoquery.execsql;
adoquery1:=TADOQuery.Create(self);
adoquery1.Connection:=ADOConnection1;
adoquery1.SQL.Text:='select * from tablename;
adoquery1.Open;
adoquery1.Free;