Adodb

[rishi_375]

Hi,
I use adodb. I try to read data from one table and add into another table.
I create two recordset. now i use do while loop till eof and read data but last row cannot be insert in the table.

my code is:

do while not rsTestUser.eof
rsTest.addnew

rsTest.fields(0) = rsTestUser(0)

rsTestUser.movenext
loop

Suppose i have 5000 row in TestUser table it add only 4999 row in next table.

Any solution.

Thanks.

 

[pono1]

do while not rsTestUser.eof
rsTest.addnew

rsTest.fields(0) = rsTestUser(0)
rstest.update

rsTestUser.movenext
loop

 

[rishi_375]

Thanks lot.

 

[pono1]

You're welcome.