今天做项目的时候，一个INSERT INTO语句把我害的要死，语句是这样的
insert into jobs(JobName, Count, Education, Salary, Place, Required) values('" & jobname &"', " & cint(jobcount) & ", '" & education & "', '" & salary & "', '" & place & "', '" & required & "')"
执行后提示“INSERT INTO 语句的语法错误”，我检查了N遍，就是没有发现哪里有语法错误，google一下，才知道我用了ACCESS数据库的保留字Count，这样处理就OK了
insert into jobs(JobName, [Count], Education, Salary, Place, Required) values('" & jobname &"', " & cint(jobcount) & ", '" & education & "', '" & salary & "', '" & place & "', '" & required & "')"
insert into jobs(JobName, Count, Education, Salary, Place, Required) values('" & jobname &"', " & cint(jobcount) & ", '" & education & "', '" & salary & "', '" & place & "', '" & required & "')" insert into jobs(JobName, [Count], Education, Salary, Place, Required) values('" & jobname &"', " & cint(jobcount) & ", '" & education & "', '" & salary & "', '" & place & "', '" & required & "')"