insert 语句 access数据库

Question

这句话有错吗，提示是：“insert into 语句的语法错误”
procedure addoftencheck(d_oftenname,d_pay,d_get,d_allneed:string）;
begin
  with TADOQuery.Create(application)  do
  begin
    Connection:=dataMod.ADOConnection;
    sql.Text:='insert into oftencheck (ptime,bossname,pay,get,allneed)ValUES('''+datetostr(date)+''','''+d_oftenname+''','''+d_pay+''','''+d_get+''','''+d_allneed+''')';
    ExecSQL;
    free;
  end;
end;

Answer 1

'insert into oftencheck (ptime,bossname,pay,get,allneed) Values('+''''+datetostr(date)+''''+','+''''+d_oftenname+''''+','+''''+d_pay+''''+','+''''+d_get+''''+','+''''+d_allneed+''''+')';
假设各字段都是字符型的。

Answer 2

可是我下面这段是对的呀，我没有加#procedure addBoss(A_name,passWord:string);
begin
  with TADOQuery.Create(application)  do
  begin
    Connection:=dataMod.ADOConnection;
    sql.Text :='insert into userInfo (username,userpassword,adddate)ValUES('''+A_name+''','''+passWord+''','''+datetostr(date)+''')';
    ExecSQL;
  end;
end;

Answer 3

sql.Text:='insert into oftencheck (ptime,bossname,pay,get,allneed) ValUES(datetostr(date)+''','''+d_oftenname+''','''+d_pay+''','''+d_get+''','''+d_allneed+''')';
试试！

Answer 4

都不对，难道不是这个语句的问题？
shomessage(sql.text)，
结果为：
　　insert into oftencheck (ptime,bossname,pay,get,allneed)values('05-3-24','111','0','1','-19')

Answer 5

sql.clear 了吗?
在查询分析器里手动执行一下试一试,
逐个排查,如先:insert into oftencheck(ptime) values ('05-3-24')
再insert into oftencheck (ptime,bossname )values('05-3-24','111')

Answer 6

谢谢楼上的兄弟们，我找到问题了，
把“get”改为"gets"就可以了，可能　get是关键字，所以出错