各位好:有条SQL语句,在下实在弄不明白

[trendvb]

是这样的,这条SQL老过不去,请大家看看问题出在哪里

For i = 1 To 100
AdoCN.Execute "insert into temp_jh " & _
"(ID,商品编号,商品全称,型号,单位,单价,数量,金额) values " & _
"(i,'sdf','dsf','dd','dd',0,0,0)"

next i
其中ID为数字型字段.

提示:至少有一个参数没指定值

如果不循环,把I改成任意一数字的话,比如25,就能添加成功一条记录

放在循环里就不行了.

这是为什么呀

[nik_Amis]

ID是不可重复的吧?你的数据库里面是否已经存在了一些数据?
ID可以改成自增,或者GUID

[duckcn]

For i = 1 To 100
AdoCN.Execute "insert into temp_jh " & _
"(ID,商品编号,商品全称,型号,单位,单价,数量,金额) values " & _
"(" & i & ",'sdf','dsf','dd','dd',0,0,0)"

next i

[ykn]

For i = 1 To 100
AdoCN.Execute "insert into temp_jh " & _
"(ID,商品编号,商品全称,型号,单位,单价,数量,金额) values " & _
"(" & i & ",'sdf','dsf','dd','dd',0,0,0)"

next i

[homerlo]

For i = 1 To 100
AdoCN.Execute "insert into temp_jh " & _
"(ID,商品编号,商品全称,型号,单位,单价,数量,金额)values "& _
"(" & i & ",'sdf','dsf','dd','dd',0,0,0)"

next i

[penper]

"(i,'sdf','dsf','dd','dd',0,0,0)"
i是字符串i，不是当前整数。
楼上俩位对。

[dot_net]

AdoCN.Execute "insert into temp_jh " & _
"(ID,商品编号,商品全称,型号,单位,单价,数量,金额) values " & _
"(" & CStr(i) & ",'& sdf & "','" & dsf & "','" & dd & "','" & dd & "'& "," & CStr(0) & "," & CStr(0) & "," & CStr(0) & ")"