DB.Execute "insert into liecyxxx values('" & Combo1.Text & _
"','" & Text1.Text & _
"','" & Text2.Text & _
"','" & Combo2.Text & _
"','" & Text3.Text & _
"','" & CDate(Text4.Text) & _
"','" & Combo3.Text & _
"','" & CDate(Text5.Text) & _
"','" & Combo4.Text & _
"','" & Text6.Text & _
"','" & Text7.Text & _
"'," & Text8.Text & _
"," & Text9.Text & _
",'" & Text10.Text & _
"'," & Text11.Text & _
"," & Text12.Text & _
",'" & Text13.Text & "')"这里,我把 combo1,text1,text2,combo2,text4(日期型数据),text5(日期型数据)设为必填字段,其余的允许为空.tex8,text9,,text11,text12为数字型,其余的都是字符型数据.我在输入数据的时候,必填的字段都 赋予了值,那些允许为空的字段就没有输入任何值.运行的时候,系统提示"insert into 语句语法错误".请帮忙解决!!!!
"','" & Text1.Text & _
"','" & Text2.Text & _
"','" & Combo2.Text & _
"','" & Text3.Text & _
"','" & CDate(Text4.Text) & _
"','" & Combo3.Text & _
"','" & CDate(Text5.Text) & _
"','" & Combo4.Text & _
"','" & Text6.Text & _
"','" & Text7.Text & _
"'," & Text8.Text & _
"," & Text9.Text & _
",'" & Text10.Text & _
"'," & Text11.Text & _
"," & Text12.Text & _
",'" & Text13.Text & "')"这里,我把 combo1,text1,text2,combo2,text4(日期型数据),text5(日期型数据)设为必填字段,其余的允许为空.tex8,text9,,text11,text12为数字型,其余的都是字符型数据.我在输入数据的时候,必填的字段都 赋予了值,那些允许为空的字段就没有输入任何值.运行的时候,系统提示"insert into 语句语法错误".请帮忙解决!!!!
text8=0
text9=0
text11=0
text12=0
Text6=""
Text13=""
然后再
DB.Execute
sql="insert into liecyxxx values('" & Combo1.Text & _
"','" & Text1.Text & _
"','" & Text2.Text & _
"','" & Combo2.Text & _
"','" & Text3.Text & _
"','" & CDate(Text4.Text) & _
"','" & Combo3.Text & _
"','" & CDate(Text5.Text) & _
"','" & Combo4.Text & _
"','" & Text6.Text & _
"','" & Text7.Text & _
"'," & Text8.Text & _
"," & Text9.Text & _
",'" & Text10.Text & _
"'," & Text11.Text & _
"," & Text12.Text & _
",'" & Text13.Text & "')"
然后你debug看一下里面具体是什么,如果觉得没错的话现在两个date类型的拿出来看看是不是有错,如果date拿出来没有错误了就是date