The sample program consists of the Update Staff Information dialog box shown below.

Update Staff Information Dialog Box

In the Update Staff Information dialog box, individual rows of data from the Staff table appear one at a time. The sample program includes ESL code for the following push button responses:

•In response to the Update push button, update the displayed record.

•In response to the Delete push button, delete the displayed record.

•In response to the Next push button, make the next record in the database table appear in the dialog box fields.

To implement these responses, the sample program uses DB/Assist to build a SELECT statement with a FOR UPDATE OF clause, a positioned UPDATE statement, and a positioned DELETE statement, as described in Creating the Program with DBAssist.

The multi-row SELECT statement in the sample program includes a FOR UPDATE OF clause that identifies all of the columns to be updated in the database table. However, adding a FOR UPDATE OF clause is optional if you check the MIA Standards Compliance box in the Bind Options dialog box, as described in Setting Bind Options. If the MIA Standards Compliance box is not checked, the FOR UPDATE OF clause is required.