本人的一个信息系统,在执行修改按钮时出现下面的错误:
General SQL error.
[Microsoft][ODBC Microsoft Access Driver] UPDATE 语句的语法错误。
部分代码如下:
query1.sql.add('UPDATE course set name:=s0,speciality:=s1,department:=s2,time:=s3,score:=s4,semester:=s5,book:=s6,op:=s7,moditime:=s8 where number:=s9');
query1.Params.clear;
query1.Params.CreateParam(ftstring,'s0',ptinput);
query1.Params[0].Value:=edit2.text;
query1.Params.CreateParam(ftstring,'s1',ptinput);
query1.Params[1].Value:=combobox1.text;
query1.Params.CreateParam(ftstring,'s2',ptinput);
query1.Params[2].Value:=edit5.text;
query1.Params.CreateParam(ftstring,'s3',ptinput);
query1.Params[3].Value:=edit3.text;
query1.Params.CreateParam(ftInteger,'s4',ptinput);
query1.Params[4].Value:=StrToInt(edit4.text);
query1.Params.CreateParam(ftstring,'s5',ptinput);
query1.Params[5].Value:=edit6.text;
query1.Params.CreateParam(ftstring,'s6',ptinput);
query1.Params[6].Value:=edit7.text;
query1.Params.CreateParam(ftstring,'s7',ptinput);
query1.Params[7].Value:=username;
query1.Params.CreateParam(ftdatetime,'s8',ptinput);
query1.Params[8].Value:=Date();
query1.Params.CreateParam(ftstring,'s9',ptinput);
query1.Params[9].Value:=edit1.text;
急......过几天毕业答辩要用的.