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.1 Classes

6.1.4 FJDB-RECORDSET Class

�¡Methods

• ADD-NEW-RECORD
• BIND-FIELDS
• DELETE-RECORD
• EDIT-RECORD
• GET-BOOKMARK
• GET-EDIT-MODE
• GET-NAME
• GET-RECORD-COUNT
• GET-SQL
• IS-BOF
• IS-BOOKMARKABLE
• IS-EOF
• IS-SCROLLABLE
• IS-UPDATABLE
• MOVE-FIRST
• MOVE-LAST
• MOVE-NEXT
• MOVE-PREVIOUS
• REFRESH-RECORDSET
• SET-BOOKMARK
• SET-NAME
• UPDATE-RECORD

�¡Function

The FJDB-RECORDSET class represents the result of a search (row set) through a database made by a specified query (SQL statement).

With the DB access class library, each individual object (database search result) of the FJDB-RECORDSET class is called a recordset.

�¡Explanation

Objects of the FJDB-RECORDSET class are created using the OPEN-RECORDSET method or CREATE-OBJECT method in the FJDB-DATABASE or FJDB-COMMAND class.

[Creating an object of the FJDB-RECORDSET class]

(Using an OPEN-RECORDSET method)

INVOKE DATABASE-A "OPEN-RECORDSET" USING SQL OPT RECORDSET-A
                                    RETURNING RET-CODE.

For more information on creating an object of the FJDB-RECORDSET class using an OPEN-RECORDSET method, see OPEN-RECORDSET Method.

(Using a CREATE-OBJECT method)

INVOKE FJDB-RECORDSET "CREATE-OBJECT" USING SQL RSOPT RSORT DSN UID PWD SCM OPT ERROR-A
                                      RETURNING RECORDSET-A.

For more information on creating an object of the FJDB-RECORDSET class using a CREATE-OBJECT method, see Creating an Object of the FJDB-RECORDSET Class.

Using methods in the FJDB-RECORDSET class, users can:

• Relocate the current row of a recordset.

  (to move to the first row, to the next row, to the previous row or to the last row)

• Update a row of a recordset.

  (to add, update, or delete rows)

Contents Index