How to do this

Aal · October 31st, 2004, 05:18 AM

Hi
I have 5 textbox in array, five fields in my tables. To add the records in that tables, I want to make an insert into statement in a loops ( For . . . Next ), and i want to make it with SQL Statements
"INSERT INTO T_Member VALUES('" & txt(x-1).text & "')"
But there's some error msg i had with a different msg, like Item not found and else in my table. And how to convert in a loops if i have one field with Number Data Type or OLE.
My thank's and appreciation for all suggestions . . .

gbianchi · November 1st, 2004, 09:11 AM

hi there..
just use one insert statement, do something like this

Code:

ssql = "insert into t_member values ("
for i = 0 to textbox.count
[tab]ssql = ssql & textbox(i).text & ","
next i
ssql = mid(1,ssql(len(ssql)-1) & ")"

HTH

Gonzalo

Aal · November 11th, 2004, 02:38 AM

thank u for your replies . . . that's works for me
but how if i want to check, a different data type of a field when i do a looping in a looping . . .thank's again for your replies. ( let's assume that i used Access database )