A Recordset is a temporary table of data in memory.

A Recordset is created from a Data Store through a Data Provider.

SYNTAX of the Open method.

recordset.Open   Source,  Connection,  CursorType,  LockType,  Options

Source The source of the recordset's data. Usually a table name or a SQL statement.
Connection The connection object defined earlier in the code.
CursorType Access methods:

   - Can find and update data.
   - Can move forward and backward through the recordset.
   - Can see changes made by other users.

   - Provides a static copy of the recordset.
   - Can move forward and backward through the recordset.
   - Can NOT see changes made by other users.

   - Like the static cursor, except only forward scrolling allowed.

   - Like a dynamic cursor, except other users changes are NOT visible.

LockType adLockReadOnly
   Read-only access

   Provider is responsible for successful editing.

   Provider locks records when Update method is invoked.

   For batch updates.

Options adCmdTable
   The Data Source is a table

   The Data Source is a text file.

   The Data Source is a stored procedure.

Print the field names (from first row)

Reference an individual field

Get the rows all at once

Copyright © 2006-2018, LQSystems,Inc. All rights reserved.

   Printer Friendly Page

ADO Home