Show TOC

Procedure documentationDefining Local Fields Locate this document in the navigation structure

 

Defining local fields allows you to generate new information from the fields in an InfoSet, without having to include an additional field.

Example Example

The DEMO_FLBOOKING InfoSet contains a field for distance and a field for flight time. A local field is used to calculate the speed of the journey.

End of the example.

Prerequisites

You are in the Field Selection screen and want to create a new query or change an existing query.

Procedure

Creating a local field

  1. Use the and functions to navigate in the Field Selection screen.

  2. Choose the   Edit   Local   Field   Create   menu option.

  3. Type the appropriate information into the Field Definition dialog box. See Dialog Box Field Definition.

  4. When you have typed in all the necessary information for your local field, click on to return to the Field Selection screen.

    The field you have defined is now included in the specified field group and can be used on all screens, just like any other field from the InfoSet.

Changing/deleting local fields

To change or delete a local field on the Select Field screen, place the cursor on the local field and choose the relevant function from the Edit menu.

Caution Caution

Local fields are only known within the query where they are defined.

End of the caution.

More Information