我怎么删除不了数据呢？？

Question

delete from ph where id=8

Answer 1

不知道怎么回事现在可以删除啦！！~~但是写到adoquery.sql.text里怎么写，哪为大哥指教指教

Answer 2

c2:=form4.ADOQuery2.FieldByName('id').AsString;
sqlstr:='delete from ph where id='+trim(c2)+';
form4.ADOQuery2.Close;
form4.ADOQuery2.SQL.Clear;
form4.ADOQuery2.SQL.Text:=sqlstr;
form4.ADOQuery2.ExecSQL;
id是自动编号

Answer 3

c2:=form4.ADOQuery2.FieldByName('id').AsString;
sqlstr:='delete from ph where id='+trim(c2)+';
form4.ADOQuery2.Close;
form4.ADOQuery2.SQL.Clear;
form4.ADOQuery2.SQL.Text:=sqlstr;
form4.ADOQuery2.ExecSQL;
id是自动编号

Answer 4

sqlstr:='delete from ph where id='+trim(c2)+';
应该改为sqlstr:='delete from ph where id='+trim(c2);

Answer 5

c2:=form4.ADOQuery2.FieldByName('id').AsString;
sqlstr:='delete from ph where id=:id';
form4.ADOQuery2.Close;
form4.ADOQuery2.SQL.Clear;
form4.ADOQuery2.SQL.add(sqlstr);
form4.ADOquery2.sql.parambyName(id).asstring:=trim(c2);
form4.ADOQuery2.ExecSQL;
id是自动编号
ok