ColumnAttributes property

Applies to
TIB_Statement

Declaration
Property ColumnAttributes : TIB_StringList;

Description
This is a special property that allows custom attributes for the columns of this statement to be stored.

So far there are the following definitions utilized by other components and controls:


// Used in column object creation. It tells that the column is actually a
// COMPUTED BY derived column.
IB_COMPUTED = 'COMPUTED';

// 53bit integer based numeric objects.
IB_NOROUNDERR = 'NOROUNDERR';
IB_CURR = 'CURR';
IB_COMP = 'COMP';

// Used for searching
IB_NOCASE = 'NOCASE'; // Flag to set a case insensitive field.
// < colname >=NOCASE=< nocasecolname >;
IB_NOTRAILING = 'NOTRAILING'; // Flag to use STARTING on literal strings.

// Used by the SeachPanel
IB_NOINSERT = 'NOINSERT';
IB_NOEDIT = 'NOEDIT';
IB_NOSEARCH = 'NOSEARCH';

If a column is defined as a BOOLEAN then the TIB_Grid will use checkbox glyphs and work just like a checkbox control. The BOOLEAN values for the column default to 'T' and 'F' for string type columns and 0 and 1 for numeric type columns. It is possible to define custom values for BooleanTrue and BooleanFalse by including a parameter value to the ColumnAttributes BOOLEAN entry. An example below:

MYCOLUMN=BOOLEAN=Y,N;< another parameter if necessary semicolon separated >

This will use 'Y' as the BooleanTrue value and 'N' as the BooleanFalse value. It is possible to set multiple ColumnAttributes on a single entry. Simply separate then by using a semicolon.

If a column is nullable then there will be three possible states when clicking on the cell. True, False and Grayed. If a column is defined as NOT NULL then it will only toggle between True and False.

It is also important to remember that the IB_Grid control has a new property called IndicateBooleans which allows the developer to turn this feature on and off at the control level too.

Refer to the help on the TIB_StringList class to see how to use and work with link entries and their parameters. The only one so far that uses a parameter is the NOCASE setting and an example of a link entry with it defined is above.