In the following example, Empform is a form created with the VIFRED. The simple fields in the form correspond to Projname and Hours in the database. Ingres reads the data into the fields on the form.

Note that it is not necessary that these fields have the same names as the names of database columns, but they must match in data type. If the names are different, the assignment statement must specify them as shown below:

The retrieve statement is described in further detail below and in The Retrieve Statement and Retrieve (QUEL).