在vb中写一个数据库的插入语句,
dim a() as variant
a=array("Id1","Id2","Id3")
Sql = "Insert Into " + TableName + " (a(0),a(1),a(2)) Values(1,2,3)"
用数组时,不能实现
但是如果
不用数组,直接用字段名时是正常的
dim a() as variant
a=array("Id1","Id2","Id3")
Sql = "Insert Into " + TableName + " (a(0),a(1),a(2)) Values(1,2,3)"
用数组时,不能实现
但是如果
不用数组,直接用字段名时是正常的
注意中间的分割
a=array("Id1","Id2","Id3")
Sql = "Insert Into " + TableName + " (" & a(0) & "," & a(1) & "," & a(2) & ") Values(1,2,3)"