gapi Active Member Licensed User Longtime User Mar 26, 2012 #1 ExecNonQuery2 array as objects Hi all, how can I get an object list (the second parameter of the ExecNonQuery2 function) in a loop for next ? Currently I use it inline Array as Object ... Code: SQL1.ExecNonQuery2("INSERT INTO " & tablename &" VALUES (?,?,?)", Array As Object (ColumnContent(0), ColumnContent(1), ColumnContent(2))) tnx Last edited: Mar 26, 2012
ExecNonQuery2 array as objects Hi all, how can I get an object list (the second parameter of the ExecNonQuery2 function) in a loop for next ? Currently I use it inline Array as Object ... Code: SQL1.ExecNonQuery2("INSERT INTO " & tablename &" VALUES (?,?,?)", Array As Object (ColumnContent(0), ColumnContent(1), ColumnContent(2))) tnx
Erel B4X founder Staff member Licensed User Longtime User Mar 26, 2012 #2 Something like: Code: Dim list1 As List. list1.Initialize For i = 0 to 10 list1.Add(ColumnContent(i)) Next 'Now you can use list1 instead of the array. Upvote 0
Something like: Code: Dim list1 As List. list1.Initialize For i = 0 to 10 list1.Add(ColumnContent(i)) Next 'Now you can use list1 instead of the array.
