Show TOC

Assigning Short NamesLocate this document in the navigation structure

Use

Each field made available through an InfoSet can have a short name. You need these short names if you want to place the value of a field in a header (more information: Headers and Footers) or calculate a local field (more information: Defining Local Fields).

Note

Only in these cases do you need to assign a short name.

Prerequisites

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

Procedure

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

  2. If the input fields for the short names do not appear automatically, choose the Start of the navigation path Edit Next navigation step Short Names Next navigation step On/Off End of the navigation path function.

  3. Type the short names into the appropriate input fields.

    Caution

    A short name has a maximum of 10 characters. It must always begin with a letter, and contain only letters, numbers, and underscores (' _ ').

Extra Functions

If you want to know whether a short name is needed, place the cursor on the field concerned or on the short name and select Start of the navigation path Edit Next navigation step Short Names Next navigation step References End of the navigation path. You get a list of all the places in the query definition where the short name is used.

Note

This function only returns a where-used list for the short names. It does not indicate which sublists of the query use the associated field.

Example

The section on defining local fields, tells you how to determine a local field that uses the fields Distance and Flight Time. Short names are assigned to these two fields.