Using Move Methods with Recordsets
Written by Eric Smith, Northstar Computer Systems LLC
Some readers have had various problems using the Move methods with their Recordset objects. The basic rule is that the recordset must support bookmarks or backward cursor movement to allow use of all the methods. If you have a forward-only recordset, the only method that is available is MoveNext. Anything else will cause a run-time error. All other types of recordsets (static, dynamic, keyset) will allow the use of MovePrevious, MoveNext, MoveFirst, and MoveLast. Disconnected recordsets will also work with all these methods.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 1/1/2000
|