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.30 IS-UPDATABLE Method

�¡Class

FJDB-RECORDSET-class

�¡Function

Returns information as to whether a recordset is updatable or read-only.

�¡Synopsis

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

�¡Object identifier

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

Specifies an object of the FJDB-RECORDSET class.

�¡Return value

UPDATABLE [attribute:S9(9) COMP-5]

Returns a nonzero value if the recordset is updatable; if not, returns a value of 0.

�¡Explanation

Whether a recordset is updatable or read-only depends on the coding format of the SQL statement that is specified when the recordset is created and also on whether a read-only flag is set.

If the mode of entry of the SQL statement that is specified at recordset creation meets any one of the following conditions, then the recordset is not updatable:

• The DISTINCT operand is included in the selection list.
• A value expression other than unary string, such as an operation expression and a constant, is included in the selection list.
• The same unary string appears more than twice in the selection list.
• A PRIMARY KEY does not exist in the table specified in the FROM phrase.
• None of the columns that make up the PRIMARY KEY are entered in the selection list.
• More than one table is entered in the FROM phrase.
• A subquery is entered as a search condition.
• Any of the GROUP BY or ORDER BY phrase, a set function or UNION is involved.

Contents Index