Skip to Content
0
Former Member
Apr 08, 2006 at 02:43 PM

Sql and recordset in .net

37 Views

Hi !

I have a RS.DOQUERY that returns about +/- 50 rows. I would like to put the data in my table row by row. I use this

Do While Not RS.EOF
                        Inv = RS.Fields.Item("RSDOC").Value
                        Bp = RS.Fields.Item("RSCRD").Value
                        Dte = RS.Fields.Item("RSDATE").Value
                        Styl = RS.Fields.Item("RSITM").Value

RS.DOQUERY ("INSERT INTO [@TABLE] .......")

RS.MOVENEXT()
LOOP

When i run my code it gives me the error Invalid Row..

Thanks !!

Alain