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.37 REFRESH-RECORDSET Method

ĦClass

FJDB-RECORDSET-class

ĦFunction

Reexecutes the SQL statement executed to create a recordset, to recreate the set.

ĦSynopsis

INVOKE RECORDSET-A "REFRESH-RECORDSET" RETURNING RET-CODE.

ĦObject identifier

RECORDSET-A [attribute:FOBJECT REFERENCE FJDB-RECORDSET]

Specifies an object of the FJDB-RECORDSET class.

ĦReturn value

RET-CODE [attribute:FS9(9) COMP-5]

Returns a value of 0 if the method ends normally; otherwise, returns an error code.

ĦExplanation

The REFRESH-RECORDSET method is used to recollect the latest version of data from the database to eliminate inconsistencies between the database and the local cache caused by calls to the ROLLBACK-TRAN method and updates from other terminals.

All edits in process are canceled when a REFRESH-RECORDSET method is issued.

All bookmark settings on the recordset are canceled.

When a REFRESH-RECORDSET method is issued, the first row of the recordset that has been recollected is set in the bind table.

Contents Index