Tables

The Table Maintenance program is used to define aliases for data files as well as records that don't map to data files.

$image\ebx_-766047401.png$

Header

Table Alias	The Table Alias must follow standard identifier naming rules: It must start with a letter. It must contain only letters, numbers and underscores ("_"). It is automatically converted to uppercase. To see a list of existing Tables, select ViewèRecord Query from the menu, press Ctrl+Q, or press the $image\ebx_1906207440.png$ tool button.
Description	Enter a short description describing the purpose of this table.
Window Title	Enter the title to be used on forms generated for this table.
Created	Displays the date on which this table was first created.
Revised	Displays the date on which this table was last changed.

Alias Definition

Alias Type	Alias type is selected from the following list: Mkeyed File Xkeyed File Vkeyed File Single Mkeyed File Serial File Direct File Indexed File Sort File String File Child Alias Indicates that this alias is an alternate view of an existing (parent) alias. If the Child Alias type is selected, "Parent Alias" must be filled in. Options Entry Indicates that this alias defines data to be entered using an Options Entry Form or an Options Entry Grid; it doesn't write data permanently to a data file. Reference Indicates this alias is a reference only, or "documentation" record not associated with any disk table.
Parent Alias	If defining a "Child Alias" (an alternate view), the "Parent Alias" is the controlling alias that defines the file.
Primary Table	Not currently used.
Disk File Name	The base filename.
Table Path	The path to the file.
Key Length	Valid key sizes are: Single Mkeyed File 1..120 Direct File 1..64 Sort File 1..64
Records	A non-zero number of records must be specified for Direct and Sort Files.
Record Length	A record length in the range 1..32767 must be specified for Direct, Indexed, and Single Mkeyed files.

Security

System ID	Enter a two-character Application ID code from this list: $image\ebx_-599372537.png$
Restrict Table Rebuild	Disallows table rebuild.
Export to Inquiry System	The inquiry system allows ad hoc SQL queries. To disable ad hoc queries for this table, deselect "Export to Inquiry System".
Solution Comp ID	This alphanumeric code identifies the company that is defining this table.
Solution Prod ID	This alphanumeric code identifies the primary product that will use this table. For example, an inventory master file is typically used by multiple applications, but its Solution Product ID would typically be the Inventory Control application.

Element Detail

Element Type	Enter an existing Element Type ID.
Description	The description is displayed from the Element Type.
Data Element	Defaults to the same as the Element Type. The Data Element is the actual variable name used in the record and template for table access. This value must be unique within the Element Detail records for a specific table.
Mult	Mult specifies the multiplier for the length of the Element Type within a field. For example, if an Element Type/Data Element ("RESERVE_TEXT") with a length of 5 bytes is entered, along with a Mult value of 4, the actual field length in the table will be 20 bytes (5 bytes * 4).
Occ	Occ specifies the number of occurrences for a specfic Element Type/Data Element within a table. For example, if an Element Type/Data Element ("SALES_AMT") with a length of 10 bytes is entered, along with a Occ value of 12, the table will actually contain 12 fields ("SALES_AMT_01"- "SALES_AMT_12"), each with an length of 10 bytes.
Delim?	Indicates whether this field is fixed-length or delimited.
Delim Char	If this is a delimited field, select the delimiter character from the list.

Table Options

To access Table Options, right-click in the form header, select RecordèOptions from the menu, press Ctrl+O, or press the $image\ebx_345313566.png$ tool button.

$image\ebx_845253965.png$

Key Definitions

$image\ebx_-1936078474.png$

Table Comments

Free-format notes relating to this table.

$image\ebx_-80327818.png$

Rebuild Table

Used to rebuild the table and data file after making changes to the Table Definition.

Rebuild Template

The table template is rebuilt, and the definition is exported to the Inquiry System, if specified in the Security section of Table Maintenance.

Form Manager

The Form Manager is the entry point to the Form Designer. To run the Form Manager, select DesignèForm Manager from the menu bar, press F8, select Form Manager from the Development application menu, or press the $image\ebx_-706049981.png$ tool button.

$image\ebx_-1007427460.png$

The Form Manager presents a list of Table aliases with the following information:

ID	Table/Alias ID
Description	Table Description
Atype	Alias type
Ftype	Form type
Disk File	Disk file name
Sys	System code
Comp	Company code
Prod	Product code
Rev Date	The last time the table or form information was revised
Build Date	The last time the form was rebuilt

Build Defaults

To set default values for some form options, select DesignèSet Build Defaults from the menu bar.

$image\ebx_177553402.png$

Options selected here act as overrides; they supercede options selected in the Form Designer.

Form Designer

The Form Designer is the central workbench for creating and editing forms. To run the Form Designer, press ENTER or double-click on an alias in the Form Manager list, select DesignèForm Designer from the menu bar, or press the $image\ebx_-1878823936.png$ tool button.

$image\ebx_1295536948.png$

The Form Designer is organized around three panels:

Columns shows the individual components that make up the form, including the table alias, the data elements within that table, and optional derived components, described below.
Attributes shows the attributes of the currently selected column.
Form shows a preview of the form; this is also the form editor.

Columns

A database table is a set of data elements organized into horizontal rows (records) and vertical columns (fields). In the following sample table, Description is a column and the record for Item 000002 is a row:

$image\ebx_-1735343835.png$ Within the Barista Form Designer, the Columns panel lists the individual table columns. It also includes a reference to the table itself and (optionally) derived elements, described below. A column can be dragged and dropped within the list to move it on the form. Select an item on the Columns panel to view or edit that item's attributes.

Form Attributes

To view or edit overall form attributes, select the ALIASNAME.<<ALIAS>> item at the top of the Columns panel. The following form attributes are available:

Add Options	Click here to define program options to be accessed using the Options menu, or to be associated with buttons added to the bottom of the form: $image\ebx_850227508.png$ Description The option description will appear on the options menu and/or the button label. Code A unique callpoint code to identify this option. When the user selects this option, Barista runs the code defined for the "After Option Select" callpoint for this code. For example: $image\ebx_-1887846819.png$ Callpoint code is edited in the Callpoint Editor, described below. Location Select one of: Options Menu to add this option to the Options tool button. This is the default. Main Form to add a button to the bottom of the generated form. Menu and Form to add this option to the Options tool button and also add a button to the bottom of the generated form.
Description	Enter a description for this form. The description will appear in the Form Manager list.
Window Title	The Window Title defaults to the same as the Description.
Dtl Grid Table	If this is a header/detail form, select the table to use in populating a detail grid.
Dtl Window Tables	Optionally select one or more associated tables. These will be added to the Options tool button.
Del Cascade Tables	Optionally select one or more associated tables. If any delete cascade tables are specified here, deleting a record from this table will also delete all related records (records with keys that start with the key to this table) from the delete cascade tables.
Del Depend Tables	Optionally select one or more associated tables. If any delete dependency tables are specified here, any attempt to delete a record from this table will be disallowed if any of the delete dependency tables contain related records (records with keys that start with the key to this table).
Data Key Name	To view data in other than primary key sequence, select an alternate key here.
Parent Alias	Imported from the Table.
Primary Table	Imported from the Table.
Form Type	The Form Type describes the form's basic structure and behavior. Barista implements four form types. Maintenance Form. A formatted screen for maintaining a table; it displays a record at a time. The Barista default form presents the data elements in a single column, with labels down the left side. This basic design can be customized using the form editor and enhanced by adding labels, tabs, group boxes, and buttons. $image\ebx_-607331019.png$ Maintenance Grid. This is also used for maintaining a table, displaying the data in a grid. $image\ebx_166718943.png$ Options Entry Form. An options entry form is used for entering a single page of information and passing it on to a program for processing. The overlay program is typically a report or batch update. $image\ebx_-967677404.png$ Options Entry Grid. This is used for entering multiple rows of information in a grid, then passing that information over to a report or update program for processing. $image\ebx_-1225163228.png$
Background Image	Select an optional background image for the form; for example: $image\ebx_-1877399325.png$ Barista comes with a standard set of images; to install additional background images, copy them to Barista\sys\images\im_back_..
Help Tag ID	Not yet implemented.
Inquiry Options	In a Form Maintenance program, Record Query presents a list of records in the table. Alternate query options can be added here. Description A short description of the alternate query option. This will appear in the "Type" dropdown list on the Inquiry form, as shown in the sample below. Alias The alternate query table. Column The alternate query column. $image\ebx_-1812842593.png$
Inquiry Restrict?	By default, grid-based forms allow the user to sort on any column by clicking in the column header. When this option is selected, grid sorting is restricted to key fields to ensure optimal performance.
Note Table	Barista provides the option to store notes for any specific record entered for any defined table. To configure this option, the developer must create a table definition with the following key format: DD_TABLE_ALIAS Specifies the table id for the record being created. NOTE_KEY The maximum length of a record key to be stored in the note table. This allows note records for multiple tables to be store in the same Note Table. Example: We want to create a single Note Table to store user notes for the following tables: EXM_CUSTOMER Key length = 6 EXM_SALESPERSON Key length = 3 The Note Table would be defined as: DD_TABLE_ALIAS (16) NOTE_KEY (6) the maximum possible length of the key from EXM_CUSTOMER and EXM_SALESPERSON NOTE_TEXT (512*)
Optional Defs	Click here to customize the form. The available options are: $image\ebx_689029026.png$ Several of these options can be set automatically using DesignèSet Build Defaults. Auto save records on exit If the user attempts to exit from a program with unsaved changes, the system normally asks if the changes should be saved: $image\ebx_387159701.png$ If "Auto save records on exit" is selected, the user doesn't see a confirmation dialog; unsaved changes are automatically saved. Redisplay record on save After the user saves a modified record, the system normally clears the Maintenance Form and moves input focus to the first field on the form. If "Redisplay record on save" is selected, the form is not cleared, and input focus is unchanged. Update all grid records on save By default, Barista updates changed rows to the database immediately, as the user moves away from the row. If this option is selected, Barista will hold all changes in memory until the user exits, then it will ask the user if all changes should be updated or discarded. Disallow window resize Forms are user-resizable by default. If "Disallow window resize" is selected, forms are not user-resizable. Use scrollbars on window resize By default, scrollbars are never shown when windows are resized. Select this option to show window scrollbars. Insert row before detail grid If this is a header/detail form, "Insert row before detail grid" inserts ROW_HEIGHT pixels (default 21) between the header area and the detail grid. Bypass new record prompt By default, the system confirms the addition of new records with: $image\ebx_-1238609491.png$ If "Bypass new record prompt" is selected, this confirmation message is omitted. Bypass delete confirmation By default, the system confirms record deletions with: $image\ebx_-1920874568.png$ If "Bypass delete confirmation" is selected, this confirmation message is omitted. Confirm all deletes In rare cases, when a deletion will have significant consequences, it might be advisable to reconfirm it before proceeding, with a message like the following: $image\ebx_1687778833.png$ Expand on new grid entry By default, when inserting a row into a Maintenance Grid using the $image\ebx_-1270443640.png$ or $image\ebx_-1919554241.png$ tool buttons, the grid is edited in place. When "Expand on new grid entry" is selected, the system opens a Maintenance Form equivalent to pressing the $image\ebx_-149093403.png$ tool button for typing in the new record: $image\ebx_-1287787325.png$ Hide saved selection options By default, Options Entry Forms include a list of saved and recent options, so that users can recall previously used options. If "Hide saved selection options" is selected, this list is omitted: $image\ebx_-86304740.png$ Destroy window on run By default, the Options Entry Form remains visible after control is passed from the Options Entry Form to the overlay program. If "Destroy window on run" is selected, the Options Entry Form is destroyed when the overlay program is started. Close after call program By default, the Options Entry Form retains control once the called program is completed. If "Close after call program" is selected, the Options Entry Form will process a normal exit. Allow Print record option Selecting "Allow Print record option" enables the FileèPrint Current Record menu item and the $image\ebx_-1058001315.png$ tool button. Allow Print all records option Selecting "Allow Print all records option" enables the FileèPrint All Records menu item. Create Options button on form By default, any options defined under "Add Options" can be accessed from the toolbar using the $image\ebx_-1829545157.png$ tool button. When "Create Options button on form" is selected, an equivalent "Options >> " button is also added to the bottom of the form. For example: $image\ebx_482854913.png$ Additional options always enabled By default, the $image\ebx_-1829545157.png$ tool button is only enabled when there is an active record on the screen. When "Additional options always enabled" is selected, the $image\ebx_-1829545157.png$ tool button is always enabled. Create function buttons on form As the user navigates through a form, either the $image\ebx_396262827.png$ or $image\ebx_-1758661219.png$ tool button is enabled if the current data element supports a "Find" or "Lookup" option. When "Create function buttons on form" is selected, the appropriate tool button is also added to the right of the data element on the generated form. Do not scale background image If a background image is selected, by default it is resized when the window is resized. If "Do not scale background image" is specified, the image size is fixed. Disallow new records By default, if the user enters a key that is not on file, the system assumes that the user is creating a new record. If "Disallow new records" is specified, new records cannot be created; the system generates the following dialog: $image\ebx_-1339271296.png$ Disallow inquiry changes By default, views in the Inquiry System can be modified by a user. This option specfies the table has a preset view that cannot be modified. Disallow all deletes This option disables the RecordèDelete menu item and the $image\ebx_-1702471243.png$ tool button.
Call Program	Options Entry forms prompt the user to enter some parameters, then press F5 or the $image\ebx_-685287560.png$ tool button to call or run an overlay program. For example, this Options Entry form prompts the user for three values (first, second, third): $image\ebx_-307929268.png$ When the user presses F5 or the $image\ebx_-685287560.png$ tool button, control is passed to the specified overlay program (either a Call Program or a Run Program). Here's a sample overlay program: rem ' Overlay for Options Entry samples rem ' If CALLed, share the workspace if tcb(13) then enter msg$="Columns = "+option!.getOptionColumns()+$0a$ msg$=msg$+"Number of columns = "+str(option!.getNumColumns())+$0a$ msg$=msg$+"Number of rows = "+str(option!.getNumRows())+$0a$ msg$=msg$+"first = '"+option!.getOptionData("first")+"'"+$0a$ msg$=msg$+"second = '"+option!.getOptionData("second")+"'"+$0a$ msg$=msg$+"third = '"+option!.getOptionData("third")+"'" i=msgbox(msg$,64,"Option Data") release This overlay program produces the following dialog: $image\ebx_41291694.png$
Run Program
Tab Definitions	If any tabs have been defined on this form, this brings up an editable list of tab labels, for example: $image\ebx_1143969934.png$

Column Attributes

To view or edit data element column attributes, select an ALIAS.COLUMN item in the Columns panel.

$image\ebx_-1288228955.png$

Element Type	Displays the Element Type for this Data Element. To view the Element Type details, right-click on the data element in the form editor and select "Maintain Element Type".
Description	Displayed from the Element Type record.
Window Label	This is the label that will be used on a generated "Maintenance Form" or "Options Entry Form".
Column Header	This is the column header that will be used on a generated "Maintenance Grid" or "Options Entry Grid".
Data Type	Displayed from the Element Type record.
Data Subtype
Control Type
Enable Column	To selectively enable this control based on the value of another column, set "Enable Column" to the column to be checked, and set "Enable Value" to the required value.
Enable Value
Check Box Values	Displayed from the Element Type record.
Ctrl Left (X)	For Maintenance Forms and Option Entry Forms, these values can be adjusted to fine-tune the placement of a control on the form. The X, Width, and Height attributes are measured in pixels, while the Y attribute is based on logical rows, with the default row height being 21 pixels. The X and Y values can be specified as relative values (+n or -n). This format is interpreted as n columns (X) or rows (Y) relative to the previous data element.
Ctrl Top (Y)
Fixed Width
Fixed Height
Data Key	Displayed from the Element Type record.
Data Table
Data Column
Data Key Name
Data Calc
Data Compress
Data Expand
Default Value	If a value is entered here, it will be used as the default (editable) value for this column. (See also Preset Value.)
Drilldown Def	To define a drilldown option for this column, select a drilldown code from the list. $image\ebx_-1355311964.png$
Group Heading	To insert a section heading, enter a title here. For example, entering a Group Heading of "Commission Info" for the "Commission Rate" column would generate this form layout: $image\ebx_-2094789877.png$
Help Tag ID	Not yet implemented.
List Data	For list-oriented controls, enter the list values here. Description This is the value that the user will see on the screen. Code This is the value that will be stored on disk. When defining a custom list, the place-holder entry must be deleted: $image\ebx_1322460747.png$
Min Length	To enforce a minimum and/or maximum length for this column, enter the length value(s) here.
Max Length
Max Rows	Displayed from the Element Type record.
Min Value	To enforce a minimum and/or maximum value for this column, enter the value(s) here.
Max Value
Mask-Input	Displayed from the Element Type record.
Mask-Output	Displayed from the Element Type record.
Mask System	To select a standard mask, enter a System ID and Mask Type code. This resolves to a mask defined in Input/Display Masks: $image\ebx_-1389702925.png$ For masking rules, refer to Numeric Masking.
Mask Type
Optional Defs	Click here to customize the behavior of this column. The available options are: Hide data in maintenance form Omits this column from Maintenance Form and Options Entry Form programs. Hide data in maintenance grid Omits this column from Maintenance Grids and Options Entry Grid programs. Hide data in inquiry system Omits this column from inquiry display. Hide data in all forms Omits this column from all forms. Hide data in Print All option Omits this column from the Print All output. Hide data in Print Record option Omits this column from the Print Record output. Hide corresponding control label Don't show the label for this column on generated Maintenance Form and Options Entry Form programs. Create total for inquiry column Adds a totals line to the bottom of the Inquiry screen showing the total for all data elements that have this option selected. For example, this can be used to show totals for the various sales figures and accounts receivable balances in the customer table: $image\ebx_1676962472.png$ Display description in grid When generating a Maintenance Grid program, this option causes the grid to display the description that corresponds to this code value. This feature assumes that table based validation rules are defined for the element type, for example: $image\ebx_-1080655736.png$ If this option is set for the state code column in the salespersons table, and the table is defined to generate a Maintenance Grid, the resulting form looks like this: $image\ebx_-145529729.png$ Save contents on conditional disable If this column is conditionally enabled (see Enable Column and Enable Value above), the default behavior is for the contents to be reset to the default value when the column is disabled. If this option is selected, the contents are retained when the column is disabled. $image\ebx_-1148108092.png$ Period/year entry control Used in Addon legacy code to specify if the Data Element should use the Addon period/year parameter settings. From/to entry control set Used when defining from/to entries in an Options Entry Form. To use this option, a single Data Element is defined in Table Maintenance with two occurrences (Occ): $image\ebx_1174565985.png$ The "From/to entry control set" option tells Barista to create two controls labeled "Beginning Value" and "Ending Value": $image\ebx_-1335865020.png$ These controls implement validation rules to ensure that the Ending value is greater than or equal to the Beginning value. In this example, the Data Element is named "RANGE". The overlay program retrieves the values using Option!.getOptionData("RANGE_1") and Option!.getOptionData("RANGE_2"). The "Beginning" and "Ending" labels are taken from the barista.ini file; they can be localized or adjusted based on personal preference: FROM_TO_LABEL_BEG=Beginning FROM_TO_LABEL_END=Ending Null entry='First' or 'Last' This option is used with a From/To entry control set based on a range of values taken from a file. When this option is selected, Barista displays descriptions of "First" and "Last" when the values are blank: $image\ebx_192397749.png$ This doesn't have any effect on the values that are returned in Option!.getOptionData(); the application must be designed to correctly interpret the meaning of these blank values. The "First" and "Last" labels are taken from the barista.ini file; they can be localized or adjusted based on personal preference: FROM_TO_DESC_FST=First FROM_TO_DESC_LST=Last Null entry='All' This option is only meaningful for data elements that are based on a file lookup. When this option is selected, Barista displays a default description of "All" when the value is blank: $image\ebx_928182561.png$ This doesn't have any effect on the value that is returned in Option!.getOptionData(); the application must be designed to correctly interpret the meaning of this blank value. The "All" string is taken from the barista.ini file; it can be localized or adjusted based on personal preference: FROM_TO_DESC_ALL=All Limit to variable naming rules Entry will be forced to uppercase. It must start with a letter and must contain only letters, digits, and underscores. Resize control on window resize On Maintenance Form and Options Entry Form programs, resize the control to use all available space. This option is only valid for the last visible control on the form. Wildcard data entry Limits entry to the characters specified in the +WILDCARD_CHARS global string. By default, this is: ABCDEFGHIZKLMNOPQRSTUVWXYZ0123456789 ? Validate entries on save only The default is to validate entry as the user tabs out of the field. Select this option to defer validation until the record is saved. Control contains external link The entry field is a command or document to be handed over to the system command processor. When this option is set, Barista adds a $image\ebx_1564217014.png$ tool button to the form after the control. When the user clicks that tool button, the text from the control is passed to the system command processor. Use last valid entry as default For the duration of a program run, the system will use the most recent valid entry as the default value for this column. Do not resolve STBL reference Overrides the default behavior where Barista attempts to resolve any text within [square brackets] as an STBL. Grid entry value must be unique When maintaining this column in a grid maintenance program, the value must be unique (i.e. the same value may not appear in the grid more than once). Display only all cases Sets this column to display-only. Display only new records only When creating a new record, sets this column to display-only. Display only existing records only When editing an existing record, sets this column to display-only. Value must be zero for record delete Disallows delete on any records containing non-zero values in the specified columns. Attempting to delete a record with a non-zero value in this column generates a message like the following: $image\ebx_-291420053.png$ Password entry control On Maintenance Form and Options Entry Form programs, this column is a password entry field; each input character is echoed as '*'. This option is only meaningful for Character Edit controls. Spellcheck control Activates spellchecking for this control. Zero based sequence number control If this is a sequence number control, start counting at zero. By default, sequence numbers start at one. Assign next sequence on null entry If this is a sequence number control, increment it on null entry. Multiple language data control Not yet implemented.
Pad Character	Displayed from the Element Type record.
Pad Alignment
Precision
User Prompt	The user prompt message is displayed in the status bar when the user enters this field.
Preset Value	If a value is entered here, it will be used as the enforced (display-only) value for this column. (See also Default Value.)
System Dialog	Displayed from the Element Type record.
Tab Location	If any tabs have been defined on this form, this dropdown list shows a list of available tabs; select a tab to move this control, along with all subsequent controls, to it. $image\ebx_-330144237.png$

Form Editor

The Form Editor is the last panel in the Form Designer. It shows a preview of the form and implements various editing features. To move a field, for example, select it and click on $image\ebx_-1924560156.png$ , $image\ebx_1754272944.png$ , $image\ebx_-23956251.png$ , or $image\ebx_-452862720.png$ , or simply drag and drop it to a new location.

$image\ebx_2094945519.png$

Form Editor Options

Right-clicking in the Form Editor brings up the following options:

$image\ebx_-1099350434.png$

Create New Tab

To add a tab control to the form, or to add a new tab to the existing tab control, select a column, then select this option and enter a tab heading.

$image\ebx_639315904.png$

Maintain Auxiliary Columns

To add columns from related tables to the form, select this option (also available via DesignèMaintain Auxiliary Columns) and select the required colums from the list. Auxiliary columns must come from a table having the same key as the form's primary table.

$image\ebx_676039771.png$

Maintain Derived Data Elements

Derived data elements, as the name implies, are derived from other data elements. To add derived data elements (sometimes called calculated fields), select this option (also available via DesignèMaintain Derived Data Elements). After entering the name of the derived data element, select an element type (which determines its overall behavior), then enter an expression that describes how the element is derived. In the expression, other columns in the table are referenced as [tablenamename.columnname].

$image\ebx_2063745542.png$

Maintain Auxiliary Labels

To add text labels to the form, select this option (also available via DesignèMaintain Auxiliary Labels) and enter the label text.

$image\ebx_-1716286574.png$

Maintain Table

To edit the table for the form, select this option.

Edit Callpoints

To edit callpoint code, select this option. The Callpoint Editor can also be accessed using DesignèEdit Callpoints, the F2 key, or the $image\ebx_1443217004.png$ tool button.

Clear Formatting Attributes

To remove various formatting attributes from the form, select DesignèClear Formatting Attributes from the menu bar, select the attributes to be cleared, and press the Clear button.

$image\ebx_-671678928.png$