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.7 DELETE-RECORD Method

�¡Class

FJDB-RECORDSET-class

�¡Function

Deletes the current row that is located in the recordset. Only the row in the table on the recordset associated with the current row is deleted.

�¡Syntax

INVOKE RECORDSET-A "DELETE-RECORD" RETURNING RET-CODE.

�¡Object identifier

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

Specifies an object of the FJDB-RECORDSET class.

�¡Return value

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

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

�¡Explanation

The DELETE-RECORD method deletes the data on the database associated with the row in the recordset, that is selected for deletion.

The current row is deleted following the issuance of the DELETE-RECORD method, but its location remains unchanged. When a MOVE-NEXT, MOVE-LAST, MOVE-PREVIOUS, or MOVE-FIRST method is issued subsequently, the current row is not located on the deleted row thereafter.

If a DELETE-RECORD method is issued to a recordset that cannot be updated, an error will be returned upon issuance.(See IS-UPDATABLE method about conditions that the recordset is not updatable.)

Once an ADD-NEW-RECORD or EDIT-RECORD method is issued, a DELETE-RECORD method cannot be issued to the same recordset or to another recordset on the same database before an UPDATE-RECORD method is issued.

Contents Index