Click to See Complete Forum and Search --> : Adding Multiple Row at once.


Solidad
May 14th, 2009, 10:29 PM
I am trying to do a multiple add on one save. like "Entry1,Entry2,Entry3," i split them and put them into a array string and add them on one DB query. here is the code

http://tinyurl.com/r3b4nc

thanks.

dglienna
May 14th, 2009, 11:52 PM
It's telling you the most likely solution as #1

= NEW ...()

Solidad
May 15th, 2009, 12:13 AM
nope its not possible DSAdd is already defined. when i put a new before DSAdd.Tables a syntax error would appear.

i have a similar code. and its working. http://tinyurl.com/r2ut7h

dglienna
May 15th, 2009, 12:48 AM
x=x & new x should work

Solidad
May 15th, 2009, 12:57 AM
nope it does not work i get a syntax telling me that it requires a end statement.

komalo
May 15th, 2009, 07:49 AM
you need to add the new table in order to add the rows
add this line before the For statement DSAdd.Tables.Add("AddDB2")