Microsoft SDK for Java

open

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)

open()

Opens a cursor.

Syntax

public void open();

open(Object source)

Opens a cursor.

Syntax

public void open(Object source);

Parameters

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.

open(Object source, Object activeConnection)

Opens a cursor.

Syntax

public void open(Object source, Object activeConnection);

Parameters

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.

open(Object source, Object activeConnection, int cursorType)

Opens a cursor.

Syntax

public void open(Object source, Object activeConnection, int cursorType);

Parameters

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.

open(Object source, Object activeConnection, int cursorType, int lockType)

Opens a cursor.

Syntax

public void open(Object source, Object activeConnection, int cursorType, int lockType);

Parameters

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.

open(Object source, Object activeConnection, int cursorType, int lockType, int options)

Opens a cursor.

Syntax

public void open(Object source, Object activeConnection, int cursorType, int lockType, int options);

Parameters

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.

© 1999 Microsoft Corporation. All rights reserved. Terms of use.