Hi,

I need to traverse a recordset.
m using sqlserver 2005 and vb6.0
I need to check the availability of data in the recordset while inserting to a database.

Thanks

__________________
Get the will power n U will be powered

Sorry, I understand the words, but not the point of the question.

Why would you "traverse" a recordset to find out if data is available?? Why wouldn't you just ask if it is and, based on a TRUE/FALSE answer, decide whether to insert or maybe update??