Question

vb6 Insert Into 语法错误，请高手指教该如何写代码

For i = 0 To 37
'sql = "Insert Into [recordall](record,guige,number) Values('" & set_record(i) & "','fk' ,'" & i + 1 & "')"
Conn.Execute sql

Next i
set_record(i) 为组数

fk字符串

Answer 1

数值字段不要加单引号。