ASP in a Nutshell, 2nd Edition

Name

Open (Recordset Object) — rsObj .Open vntSource, _ vntActiveConnection ,_lngCursorType , lngLockType , lngOptions

Synopsis

Opens a cursor into a data source.

Parameters

vntSource

A Command object name, SQL statement, table name, or stored procedure name.

vntActiveConnection

A variant value holding the name of a Connection object or a string containing valid ConnectionString text.

lngCursorType

The type of cursor you would like to create. If you attempt to create a cursor type not supported by the underlying data source, an error may occur. The valid values for the lngCursorType parameter are the following:

adOpenForwardOnly

This is the default. This parameter only allows movement forward from the current record. Otherwise this cursor type is identical to the static cursor. There is one exception to this, however. Some data providers will allow you to call the MoveFirst method to move the current record pointer back to the first record in the recordset. This is the fastest cursor type.

adOpenKeyset

In a keyset cursor, you cannot see new records added by other users and you cannot access records that have been deleted by other users. You can, however, see the changes to records in your recordset made by other users. All types of movement are possible in a keyset cursor recordset.

adOpenDynamic

Dynamic cursors are the most flexible (and slowest) of the four types. In a dynamic cursor, additions, changes, and deletions are all visible in your recordset. All types of movement ...