SQL = "Update duser set fchck=" & CheckBox1.Value & ",DDGL=" & CBoolCheckBox2.Value & "" & _
"YWGL=" & CheckBox3.Value & ",bb1=" & CheckBox8.Value & "" & _
"bb2=" & CheckBox9.Value & ",CWYY=" & CheckBox7.Value & "" & _
"where name='" & ComboBox1 & "'"
上面的代码如果没有加CBOOL函数,是通过的,但是在数据库的表内的值却为255,我的表段的类型是字节,加了CBOOL,变成如下:
SQL = "Update duser set fchck=" & CBool(CheckBox1.Value) & ",DDGL=" & CBool(CheckBox2.Value) & "" & _
"YWGL=" & CBool(CheckBox3.Value) & ",bb1=" & CBool(CheckBox8.Value) & "" & _
"bb2=" & CBool(CheckBox9.Value) & ",CWYY=" & CBool(CheckBox7.Value) & "" & _
"where name='" & ComboBox1 & "'"
则提示语法错误(操作符丢失),不知道那儿错误了?字段类型:字节!谢谢!
"YWGL=" & CheckBox3.Value & ",bb1=" & CheckBox8.Value & "" & _
"bb2=" & CheckBox9.Value & ",CWYY=" & CheckBox7.Value & "" & _
"where name='" & ComboBox1 & "'"
上面的代码如果没有加CBOOL函数,是通过的,但是在数据库的表内的值却为255,我的表段的类型是字节,加了CBOOL,变成如下:
SQL = "Update duser set fchck=" & CBool(CheckBox1.Value) & ",DDGL=" & CBool(CheckBox2.Value) & "" & _
"YWGL=" & CBool(CheckBox3.Value) & ",bb1=" & CBool(CheckBox8.Value) & "" & _
"bb2=" & CBool(CheckBox9.Value) & ",CWYY=" & CBool(CheckBox7.Value) & "" & _
"where name='" & ComboBox1 & "'"
则提示语法错误(操作符丢失),不知道那儿错误了?字段类型:字节!谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货