ADO ObjectsLesson 77Free preview
ADO Recordset
This lesson is part of ASP · All levels
Summary
The Recordset is the central ADO object that accommodates the query results and provides control over the cursor as well as line locking. The CursorType and LockType options specify abilities such as counting the number of rows, sorting, or editing. The Filter property allows screen filtering without having to run a query again.
Key points
- CursorType specifies cursor behavior such as forward-only or dynamic.
- LockType specifies the line locking strategy when editing.
- The filter filters the lines that appear without a new query.
- MoveFirst is used back to the first line of the recordset.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.