Previous Topic: Automatic Add OptionsNext Topic: Trimming an Access Path


Changing the Auto Add Setting

Do the following to change the Auto Add setting:

  1. Zoom into the file.

    Type Z next to any relation for the selected file on the Edit Database Relations panel and press Enter.

    The Edit File Details panel displays.

  2. Toggle the Auto Add setting.

    At the Edit File Details panel, type H next to the selected access path and press Enter.

    The allowable Auto Add settings and defaults are as follows.

Access Path

Atr Only

Held

All

PHY

Default

No

No

UPD

Default

Yes

No

RTV

Default

Yes

Yes

RSQ

Default

Yes

Yes

QRY

Default

Yes

Yes

A refreshed panel displays with the indicator ALL, ATR ONLY, or HELD showing that the selected access path has changed its Auto Add setting.

Note: The key relations (Known by, Owned by, and Qualified by) are added to the access path regardless of the Auto Add setting. These relations must always be present on all access paths for the file.

If a relation is added to an access path and functions that use the access path already exist, the entries that result from resolving the new relations are added to any device designs (reports and panels) used by the functions. For example, if the entries are not key fields on the access path, they will be added as hidden fields to the device designs.

If they are key fields on the access path, they are added as input fields to the device designs. The device designs may therefore require readjustment before they can be successfully regenerated.

For more information about readjusting the device designs, see the "Modifying Device Designs" chapter of Building Applications.