Tutorial Chapter 8: Modifiable DISPLAY ARRAY

The program in this chapter allows the user to view and change a list of records displayed on a form. As each record in the program array is added, updated, or deleted, the program logic makes corresponding changes in the rows of the corresponding database table.

This program uses a form and a screen array to allow the user to view and change multiple records of a program array at once. The DISPLAY ARRAY statement and its modification control blocks ON APPEND, ON UPDATE and ON DELETE are used by the program to control and monitor the changes made by the user to the records. As each record in the program array is Added, Updated, or Deleted, the program logic makes corresponding changes in the rows of the customer database table.

Figure: DISPLAY ARRAY example with modification actions

This figure is a screenshot of the code example in Chapter 8 to allow users to append, update and delete customer records.