How to determine of recordset is on the first record 3

[JacobTechy]

I am using adodc in vb6sp6 and I would like to know if the recordset is on the first record of the database. How would the code be for this.

 

[johnwm]

Assuming you are not using a forward-only cursor you can force to the first record:
rs.MoveFirst

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[Golom]

You can also look into the AbsolutePosition property of the recordset. AbsolutePosition is not supported for all recordset or cursor types however.

 

[JacobTechy]

what I want to do is:
if recordset is on first record then
???
else
?????
endif

 

[bjd4jc]

if recordset.BOF then
...
else
...
end if