Adding, Amending and Deleting Records

You may add, amend and delete records on the main table selected for your procedure body. Note that, if the user deletes a record, normally subsidiary procedures will not be executed (see Error Subsidiaries ).

The following controls in the Main Table dialog can be set up:

Controls Description
Update main table This option is particularly important for batch procedures which delete records.
Yes: records may be added, amended or deleted
No: records may be deleted, but not added or amended
Process existing records This option determines whether records on the database are processed, in addition to newly created records
Yes: records on the database are processed
No: records on the database are not processed
Allow new records Determines whether new records may be added
Allow record deletion Determines whether existing records may be deleted

A record is regarded as a new record until it has been posted and re-read from the database

To set up record deletion for a batch update program:

  1. In the Procedure Overview answer yes to Database procedure and Update database
  2. Answer no to Update main table? and yes to Allow record deletion