Add / Edit (Named IO Columns Menu)


 

The add function inserts columns into an existing View. Edit allows modification of a defined column. Clicking the Add or Edit Column Menu item will display the Column Editor.

 

columneditor.jpg

 

Column Editor Dialog Items

Column Name

Specifies the unique name of the column.

Description

Provides descriptive text regarding the column.

Type

Allows selection of a PLB column type. The schema allows Dim, Form, and Integer types.

Element Count

Allows specification of the number of elements if the column represents an array.

Offset

Defines the starting position of the column within the data row.

Length

Allows specification of the column length.

Scale

Defines the number of decimal places for Form type columns. If this value is '-1', the FORM is to have a decimal point with any fractional digits. Otherwise, this value can be from zero to the maximum number of fractional digits allowed for a PLB FORM variable

Default Value
Specifies a default value that is to be written when column names are being used in a WRITE instruction and the PLB column name for this field is not included in the PLB variable list. If the 'default_value' is empty, blanks or zeros are written as a default depending on the PLB variable type. Otherwise the 'default_value' data is written.
Format Mask
Required for ODBC driver to be implemented at a later time.

ODBC Options

 

These options are required for ODBC driver to be implemented at a later time.

 



About SchemaEditor Delete (Named IO Columns Menu)