今天做项目的时候,一个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 & "
'
)"