主题:[讨论]ADOQuery语句调试错误,
ADOQuery1.Connectionstring:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source=LicID.mdb;Persist Security Info=False';
ADOQuery1.close;
ADOQuery1.sql.clear;
adoquery1.sql.add('insert into LicID(LicNo,Company ,MacAddr,PicoloID,Dongle,Admin,AdminPW,User1,UserPW) values('+trim(DBEdit1.text)+','+DBEdit2.text+','+DBEdit3.text+','+DBEdit4.text+','+DBEdit5.text+','+'''admin'''+','+'''admin'''+','+'''admin'''+','+'''admin'''+')');
adoquery1.execsql ;
参数AB53没有默认值(AB5是LicID字段和DBEdit1.text的值)或者是
语法错误(操作符丢失)在表达式“XXY COMPANY Pte ltd”中(XXY COMPANY Pte ltd是Company和DBEdit2.text的值)
为什么呀?
ADOQuery1.close;
ADOQuery1.sql.clear;
adoquery1.sql.add('insert into LicID(LicNo,Company ,MacAddr,PicoloID,Dongle,Admin,AdminPW,User1,UserPW) values('+trim(DBEdit1.text)+','+DBEdit2.text+','+DBEdit3.text+','+DBEdit4.text+','+DBEdit5.text+','+'''admin'''+','+'''admin'''+','+'''admin'''+','+'''admin'''+')');
adoquery1.execsql ;
参数AB53没有默认值(AB5是LicID字段和DBEdit1.text的值)或者是
语法错误(操作符丢失)在表达式“XXY COMPANY Pte ltd”中(XXY COMPANY Pte ltd是Company和DBEdit2.text的值)
为什么呀?