Database Options |
|
|
|
Database Options |
|
|
Database Options |
|
|
|
Database Options |
|
|
You can define the settings that XPAC uses to display data in each database in your XPAC project. For example, you may want to display record numbers in the Yearly calendar database and Main database, but not the Monthly calendar database.
|
The settings that you specify only apply to the database that you are currently viewing. |
To specify database settings:
| 1. | Select Tools > Database Options. The Options for <databasename> Database Window displays (where <databasename> is the database you are currently viewing, for example, Main). |
| 2. | Specify the display options that you want to apply to the structure tree as required, for example, you may want to display the PIL number for each record. |
| 3. | Click OK. |
The table below describes the options available in the Database Options window:
Section |
Option |
Description |
Display Levels In Path Name |
Inserts each level name when displaying the record path in the status bar, for example:
Otherwise, XPAC only displays record numbers:
|
|
Display Record Number in Structure |
Displays the unique record number for each record in the structure tree, for example:
Otherwise, XPAC only displays the record name:
|
|
Display Absolute Position in Level (APIL) in Tree |
Displays position in level (PIL) numbers in the structure tree, for example:
Otherwise, XPAC displays only the record name:
|
|
Display Period Number in Path (Calendar Only) |
Note: This option is only available for calendar databases. Displays the period number for each record in the structure tree, for example:
Otherwise, XPAC displays only the record name:
|
|
Display Description in Transposed Views |
Displays the description of each field in the Data Field Name row (for example, Non-Acid Forming Waste) when viewing the data sheet in a transposed view. |
|
Display N/A for Upper Level Records |
Displays N/A in the cell if an upper level (no aggregate) record is blank (has no value). |
|
Display Debug Information |
Displays internal ID diagnostic information. |
|
Display Period Number in Header (Calendar Only) |
Note: This option is only available for calendar databases. Displays the period number in each header, for example:
Otherwise, XPAC displays only the record name:
|
|
Note: This option is only available for calendar databases. Displays all calendar increments in the data sheet (hides the structure tree in the main workspace). |
||
Advanced |
Field storage grow by |
Lets you specify how many database rows you want to reserve for fields that you may eventually create. |
