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.