Temp-Table Maintenance Dialog Box

Use this dialog box to add, remove, and modify Temp-table definitions within the current procedure file. You can select tables in your TEMP-DB or tables in any existing database. You can also modify existing table schema by adding optional fields and indexes. (Access this dialog box by choosing the Temp-Tables icon in the Procedure Settings dialog.)
Note: All items on the Temp-tables Maintenance box are grayed out until you select a table using the Add button.
Add Displays the Table Selector dialog. From this box select any tables not yet selected for the current procedure. After you select a table, the AppBuilder displays it in the Temp-Tables Maintenance box and activates the other options
Note: The AppBuilder uses the ABL "LIKE" syntax to define the Temp-Table. Defining the Temp-Table like an existing table causes the Temp-Table definition to be stored in ther–code during compilation, but does not require the TEMP-DB to be connected at run time. This is necessary because Temporary Tables do not exist until run–time.
Remove Removes a table definition from the current procedure after you highlight it in the display box.

To apply table properties or other options to a table, highlight it from the displayed list, then select items as described below.

New Global Shared Establishes a global shared Temporary Table. The scope of a global shared Temporary Table is the session.
New Shared Establishes a shared Temporary Table. The scope of a shared Temporary Table is the scope of the procedure that established it.
Shared Allows the procedure to access an established shared Temporary Table.
Local Allows access only from this procedure. This is the default selection.
Buffer Defines an extra buffer for the table instead of defining a Temporary Table. As with the Temporary Table, the scope of the buffer is determined by your selection from the properties listed above. For example, if you select "New Shared" and "Buffer", you are defining a new shared buffer.
NO-UNDO Increases update performance for Temporary Table. If you deselect this button, changes made to the Temporary Table during a transaction are logged to the local before image (LBI) file.
Table Name Allows you to rename your Temporary Table. The new name is updated in the Temp-Tables list as soon as you leave the fill–in.
Additional Fields Allows you to add extra fields to a defined Temp-Table. For example, you might want to maintain the schema of an existing database table, but add one or two extra fields. You can also use this fill–in to override the primary index for the table.
Note: Fields entered in Additional fields will not be available for selection in the Query Builder and other AppBuilder schema pickers. Additional Fields is reserved for less visible data, such as ROWID or a time stamp. Fields that you want available from the schema pickers should be defined in the Data Dictionary.
Check Syntax Checks the syntax of any entries in Additional Fields prior to running or saving your procedure.