Recordset. Open Method Parameters

Recordset. Open parameter description

Syntax:
Recordset. Open source, activeconnection, cursortype, locktype, options

Parameter description:
Source (optional) is a variant that calculates the variable name, SQL statement, table name, stored procedure call, or persistent recordset File Name of the command object. Activeconnection is optional. Calculates the variable name of the valid connection object, or a string that contains the connectionstring parameter.
Cursortype (optional) value of cursortypeenum to determine the type of cursor that the provider should use when opening the recordset.
Can be one of the following constants (see the cursortype attribute for definitions of these settings ).
Description of value Constants
---------------------------------------------
0 adopenforwardonly default value) open only forward type cursor.
1 adopenkeyset open the keyset type cursor.
2 adopendynamic open the dynamic type cursor.
3. Open the static type cursor in adopenstatic.

Locktype is optional. Determine the locktypeenum value of the lock (concurrent) type that the provider should use when opening the recordset. It can be one of the following constants (see the locktype attribute for details ).
Description of value Constants
----------------------------------------------------------
1 adlockreadonly (default) read-only-data cannot be changed.
2 adlockpessimistic locking: The provider completes the work required to ensure successful record editing, usually by locking the records of the data source at the time of editing.
3 adlockoptimistic open locks (one by one)-The provider uses open locks to lock records only when the update method is called.
4 adlockbatchoptimistic open batch Update-used in batch update mode (relative to the immediate update mode ).