Top
PowerCOBOL V11.0 Reference
FUJITSU Software

4.73 CursorType Property

Description:

Defines the type of cursor to be used.

Used in control(s):

ADODataSource

DBAccess

Values (with constants):

ADODataSource

Defines the type of cursor to be used in record set.

1 - adOpenKeyset: Uses the keyset cursor.
(POW-ADODB-ADOPENKEYSET)

2 - adOpenDynamic: Uses the dynamic cursor.
(POW-ADODB-ADOPENDYNAMIC)

3 - adOpenStatic: Uses the static cursor.
(POW-ADODB-ADOPENSTATIC)

Consult the ADO documentation for details about cursor types.

Note: The value may be ignored depending on the kind of OLE DB Provider to which you connected.

DBAccess

0 - SQL_CURSOR_FORWARD_ONLY: (POW-DBCURSOR-FORWARDONLY)
The cursor only advances forward through the rows.

1 - SQL_CURSOR_KEYSET_DRIVEN: (POW-DBCURSOR-KEYSETDRIVEN)
Uses the key to the number of rows set in the KeysetSize property.

2 - SQL_CURSOR_DYNAMIC: (POW-DBCURSOR-DYNAMIC)
Using a dynamic cursor.

3 - SQL_CURSOR_STATIC: (POW-DBCURSOR-STATIC)
The resulting data set contains static data.

The cursor can be scrolled apart from the value 0.

Default value:

ADODataSource

3 - adOpenStatic: Uses the static cursor.
(POW-ADODB-ADOPENSTATIC)

DBAccess

0 - SQL_CURSOR_FORWARD_ONLY: (POW-DBCURSOR-FORWARDONLY)

COBOL picture:

ADODataSource

S9(4) COMP-5

DBAccess

S9(9) COMP-5

OLE data type:

ADODataSource

VT_I2

DBAccess

VT_I4

Design time access:

Set and reference.

Execution time access:

ADODataSource

Set and reference.

DBAccess

Reference only.

Backward compatibility attribute:

None.