Show TOC

 Defining Local Fields

Use

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.

Creating a local field

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

  2. Choose the Start of the navigation path Edit Next navigation step Local Field Next navigation step Create End of the navigation path menu option.

  3. The following screen shows the local field described above with the speed of the journey as an example.

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

  5. 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.

See also: