DB Access Class Library for COBOL V1.0 API Reference - Microsoft(R) Windows(R) - - Microsoft(R) Windows NT(R) - - Microsoft(R) Windows(R) 2000 -

Contents Index

Chapter 6 DB Access Library API Reference

6.2 Methods

6.2.29 IS-SCROLLABLE Method

�¡Class

FJDB-RECORDSET-class

�¡Function

Returns information as to whether the MOVE-PREVIOUS, MOVE-FIRST, and MOVE-LAST methods can be used for a recordset.

�¡Synopsis

INVOKE RECORDSET-A "IS-SCROLLABLE" RETURNING SCROLLABLE.

�¡Object identifier

RECORDSET-A [attribute:OBJECT REFERENCE FJDB-RECORDSET]

Specifies an object of the FJDB-RECORDSET class.

�¡Return value

SCROLLABLE [attribute:�FS9(9) COMP-5]

Returns a nonzero value if the MOVE-PREVIOUS, MOVE-FIRST, and MOVE-LAST methods can be used; if only the MOVE-NEXT method can be used, returns a value of 0.

�¡Explanation

The IS-SCROLLABLE method returns information as to whether the MOVE-PREVIOUS, MOVE-FIRST, and MOVE-LAST methods can be used for a recordset to locate a row.

The MOVE-PREVIOUS, MOVE-FIRST, and MOVE-LAST methods cannot be used for these recordsets:

(1) A recordset having at least one field name of the binary type, with a definition length of 32 KB or more, entered in the selection list in the SQL statement specified when the recordset was created and one that conforms to any of the following conditions:

• A PRIMARY KEY does not exist in the table containing a field of the binary type, with a definition length of 32 KB or more, as specified in a FROM phrase.
• None of the columns that make up the PRIMARY KEY in the table containing a field of the binary type, with a definition length of 32 KB or more, are entered in the selection list.
• The table that contains a field of the binary type, with a definition length of 32 KB or more, as specified in a FROM phrase is a view table.

(2) A recordset that has been created with the following options specified:

[If access is made to a local database]

FJDB-SCRSOPT-NOCACHE is specified, but FJDB-SCRSOPT-SCROLLABLECURSOR is not specified.

[If access is made to a remote database]

FJDB-SCRSOPT-FORWARDONLYCURSOR is specified, but FJDB-SCRSOPT-CACHE is not specified.

Contents Index