This method of the Recordset class opens a cursor. open has the following signatures:
open()
open(Object source)
open(Object source, Object activeConnection)
open(Object source, Object activeConnection, int cursorType)
open(Object source, Object activeConnection, int cursorType, int lockType)
open(Object source, Object activeConnection, int cursorType, int lockType, int options)
Opens a cursor.
public void open();
Opens a cursor.
public void open(Object source);
source | A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persisted Recordset. |
Opens a cursor.
public void open(Object source, Object activeConnection);
source | A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persisted Recordset. |
activeConnection | Either a Variant that evaluates to a valid Connection object variable name, or a connection string. |
Opens a cursor.
public void open(Object source, Object activeConnection, int cursorType);
source | A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persisted Recordset. |
activeConnection | Either a Variant that evaluates to a valid Connection object variable name, or a connection string. |
cursorType | An AdoEnums.CursorType value that determines the type of cursor that the provider should use when opening the Recordset. The default value is FORWARDONLY. |
Opens a cursor.
public void open(Object source, Object activeConnection, int cursorType, int lockType);
source | A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persisted Recordset. |
activeConnection | Either a Variant that evaluates to a valid Connection object variable name, or a connection string. |
cursorType | An AdoEnums.CursorType value that determines the type of cursor that the provider should use when opening the Recordset. The default value is FORWARDONLY. |
lockType | An AdoEnums.LockType value that determines what type of locking (concurrency) the provider should use when opening the Recordset. The default value is READONLY. |
Opens a cursor.
public void open(Object source, Object activeConnection, int cursorType, int lockType, int options);
source | A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persisted Recordset. |
activeConnection | Either a Variant that evaluates to a valid Connection object variable name, or a connection string. |
cursorType | An AdoEnums.CursorType value that determines the type of cursor that the provider should use when opening the Recordset. The default value is FORWARDONLY. |
lockType | An AdoEnums.LockType value that determines what type of locking (concurrency) the provider should use when opening the Recordset. The default value is READONLY. |
options | An integer value that indicates how the provider should evaluate the source argument if it represents something other than a Command object, or that the Recordset should be restored from a file where it was previously saved. Can be one or more AdoEnums.CommandType or AdoEnums.ExecuteOption values. |