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 4 Examples of Using the DB Access Class Library

4.1 Use a Recordset

4.1.5 Update data using a recordset

4.1.5.1 Data Update Example (Using a recordset to update data)

It is a figure of following image handled.

1.Using the MOVE-FIRST method in the FJDB-RECORDSET class, locate the current row of the recordset on the first row.

2.If the data in the field "NO" in the recordset is less than 1000, delete the records from the database.

3.Using an ADD-NEW-RECORD method, add a row to the recordset.

4.Assign additional data to the variables registered in the bind table.

5. Using an UPDAT-RECORD method, update the recordset and the database with the data set in the bind table.

Contents Index