应为: ADOQuery1.SQL.Text := 'delete table1 where table1.name=''A'''name为SQL 保留字! TRY!
1: use ADOQuery, upstair 's answer is right! 2: use ADOCommand can do all SQL command to ADO DB, use it the same as ADOQuery. note: before execute SQL please close the DB first!
同意楼上, 再有,dlete from table1 where name="A" ,是不是你的格式不对啊 name='A',才合适吧!
试试ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('delete from table1 where table1."NAME"='''+'A'+''' ')
ADOQuery1.SQL.Text := 'delete table1 where table1.name=''A'''name为SQL 保留字!
TRY!
2:
use ADOCommand can do all SQL command to ADO DB, use it the same as ADOQuery.
note: before execute SQL please close the DB first!
再有,dlete from table1 where name="A" ,是不是你的格式不对啊
name='A',才合适吧!
ADOQuery1.SQL.Add('delete from table1 where table1."NAME"='''+'A'+''' ')
我试了许多次,格式与上面几位都相同。
用的是delphi 6 mssql 7