Database Accesses

• If a condition to access is specified for a table, the access is only attempted when the condition is satisfied. Otherwise processing continues as though the validation succeeded, but the value of table.there for the field is meaningless.
• The record is fetched, scanning as appropriate. During scans, only those records which satisfy validation conditions are offered and all fields from the record in the map are displayed. If multiple choice is specified, the multiple choice is only offered if a matching record is not found initially.
• If the record satisfies the relevant conditions and it is already on the database, it is pre displayed on screen (for interactive programs only).
• When the main table is accessed, change prevention and clearfirst flags are set as appropriate.
• Confirmation of updates is requested after all the fields have been processed. The user can either abort the procedure (which returns ESCAPE), resume editing the fields or confirm changes. If he resumes editing, he will be returned to the first non key field if there is one or the first field if not.