ADOConnection1.Open;
ADOCommand1.CommandText:='insert into userinfo(name,pass,state) values ('qqq','qqq','1234')'; //错误!!!
ADOCommand1.Execute;
这个sql在数据库中正确,在delphi中提示有错误,应该怎么改???
ADOCommand1.CommandText:='insert into userinfo(name,pass,state) values ('qqq','qqq','1234')'; //错误!!!
ADOCommand1.Execute;
这个sql在数据库中正确,在delphi中提示有错误,应该怎么改???
改用ADOQuery:
ADOQuery1.close;
ADOQuery1.sql.clear;
ADOQuery1.sql.add('insert into userinfo(name,pass,state) values ('qqq','qqq','1234');
ADOQuery1.exec;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ADOCommand1.CommandText:='insert into userinfo([name],[pass],[state]) values ('qqq','qqq','1234')';
//操作的字符可能是系统保留字的时候,用[]括起来!
~~~~~~~~~~~~~~~~~~~
ADOCommand1.CommandText:='insert into userinfo([name],[pass],[state]) values (''qqq'',''qqq'',''1234'')'; ' ''