insert into 语法错误,请大伙帮忙找下错误,代码如下: ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into sale_info (bookid,number,total,discount,selldate) values('''+edit1.Text+''','''+edit3.Text+''','''+label17.caption+''','''+label13.caption+''','''+datetostr(date)+''') ');
ADOQuery1.ExecSQL;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into sale_info (bookid,number,total,discount,selldate) values('''+edit1.Text+''','''+edit3.Text+''','''+label17.caption+''','''+label13.caption+''','''+datetostr(date)+''') ');
ADOQuery1.ExecSQL;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into sale_info (bookid,number,total,discount,selldate) values(:v1, :v2, :v3, :v4, :v5)');
ADOQuery1.Parameters.ParamByName('v1').Value := edit1.Text;
ADOQuery1.Parameters.ParamByName('v2').Value := edit3.Text;
ADOQuery1.Parameters.ParamByName('v3').Value := label17.caption;
ADOQuery1.Parameters.ParamByName('v4').Value := label13.caption;
ADOQuery1.Parameters.ParamByName('v5').Value := datetostr(date);
ADOQuery1.ExecSQL;
' values ('+edit1.Text+','+edit3.Text+','+
label17.caption+','+label13.caption+','''+datetostr(date)+''') ');
ADOQuery1.ExecSQL;
+' values ('
+ edit1.Text+','
+ edit3.Text+','
+ label17.caption+','
+ label13.caption+','
+ '''' +datetostr(date)+''''
+ ')' + ';'