Lesson 7 - Exploring the Form (Update) Procedure

Top  Previous  Next


The Form procedure is derived from the basic Window procedure. It generates code to display and update a single record from a table. It also generates code to display and access related records in other related tables.

The Form procedure begins by using a FORM (Add/Edit/Delete) procedure default, which provides a predefined window, a SaveButton Control template and a ValidateRecord Extension template.

The SaveButton Control template handles the table I/O and the ValidateRecord template validates incoming data according to data dictionary settings. The Data / Tables Pad automatically attaches your table choices to the SaveButton Control template. For accessing related records, the Form wizard template optionally provides a BrowseBox Control template.


Browse-Form Paradigm

The Form template is an integral part of Clarion’s Browse-Form paradigm which uses Browses (windows with sortable, scrollable, searchable, selectable lists of data), Forms (windows with a single updatable database record), and Reports to organize and present database information to end users.

A Form can deviate from this paradigm with the use of the FormVCRButtons Control template. This template provides nearly all of the functions provided by the Browse, but without the list control.


Form Template Prompts

In addition to the standard Application Generator command buttons and prompts, the Form template Procedure Properties Actions dialog contains the prompts inherited from the Window Template (Parameters, Return Value, and Window Behavior—see Window Procedure Templates – Window Template Prompts), plus the prompts provided by the ValidateRecord Extension and the SaveButton Control.



Record Validation

The RecordValidation Extension template adds additional prompts so you can control how and when record validation happens.


Save Button Properties

The SaveButton Control template provides additional prompts so you can control how and when the record is updated, including the type of updates allowed, whether multiple inserts are allowed, messages shown to the end user, and more.


Next: Lesson 8 - The Report Designer