在调试程序的时候它提示“查询值的数目与目标字段中的数目不同”,代码如下
'保存注册信息
Set adors2 = Cnn.Execute("insert into table1 values(" & StrId & ",'" & Text1& "','"&Text2& "','"&Text3& "','0','0','0','0','0','0','0','0','0','0','0','0')")
MsgBox "注册成功!!", 48, "用户注册信息提示"
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
请大家帮忙看一下是什么问题,非常感谢了!!!
'保存注册信息
Set adors2 = Cnn.Execute("insert into table1 values(" & StrId & ",'" & Text1& "','"&Text2& "','"&Text3& "','0','0','0','0','0','0','0','0','0','0','0','0')")
MsgBox "注册成功!!", 48, "用户注册信息提示"
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
请大家帮忙看一下是什么问题,非常感谢了!!!
2,不需要 set adors2=,直接cnn.exe ...
3,字符型变量引用:'"& 变量名 &"'
数值型变量引用:"& 变量名 &"Cnn.Execute "insert into table1(字段1,字段2,...) values(" & StrId & ",'" & Text1& "','"&Text2& "','"&Text3& "','0','0','0','0','0','0','0','0','0','0','0','0')"
这个问题
1.你到数据库里面把相关的表打开,数数多少个字段,有没有自增字段
2.Cnn.Execute "insert into table1(字段1,字段2,...) values(" & StrId & ",'" & Text1& "','"&Text2& "','"&Text3& "','0','0','0','0','0','0','0','0','0','0','0','0')"
数数自己添加对了没有