Default Cursor Position

[jhein]

When I have a recordset come back from the database (LockType = adLockBatchOptimistic, CursorType = adOpenStatic and CursorLocation = adUseClient) I know it is probably good practice to do a recordset.MoveFirst on that recordset before performing any actions with it, but I am just curious as to whether or not the MoveFirst is necessary? It seems as if the default cursor location is on the first record...is this true?

 

[johnwm]

Yes

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[zyrag]

however, it is always safe to invoke the .MoveFirst method. I had once experienced where it did not start from the very first record.