Try OpenEdge Now
skip to main content
Online Help
Introducing the ABL GUI Designer : Reference : GUI Designer dialogs : AppBuilder dialogs : Other AppBuilder dialogs : Temp-Table Maintenance Dialog Box
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.
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.
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.
Allows the procedure to access an established shared Temporary Table.
Allows access only from this procedure. This is the default selection.
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.
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.