代码如下:
Dim cn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Dim dogid As Integer
dogid = 11602
cn1.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=e:\data\data\hf2.mdb"
Set rs1 = cn1.Execute("insert into 加密狗ID values (dogid,0,'""','""')")
cn1.Close
出现的错误是参数不足,期待是一
此 加密狗ID 表 前两个列是数值型,后两个是整型为何会出现这种错误呢
Dim cn1 As New ADODB.Connection
Dim rs1 As New ADODB.Recordset
Dim dogid As Integer
dogid = 11602
cn1.Open "Driver={Microsoft Access Driver (*.mdb)};
DBQ=e:\data\data\hf2.mdb"
Set rs1 = cn1.Execute("insert into 加密狗ID values (dogid,0,'""','""')")
cn1.Close
出现的错误是参数不足,期待是一
此 加密狗ID 表 前两个列是数值型,后两个是整型为何会出现这种错误呢
删除Set rs1 =
Set rs1 = cn1.Execute("insert into 加密狗ID(字段名1,字段名2) values (dogid,0)")
Set rs1 = cn1.Execute("insert into 加密狗ID values (dogid,0,0,0)")
这样后面默认添加了两个0
Set rs1 = cn1.Execute("insert into 加密狗ID(字段名1,字段名2) values (" & dogid & ",0)")