CONDITION:
Attributes

ACTION

An action can be carried out on to another widget. You can change the editable status or visible status on another widget by specifying this action.

Value(s)

• visible-true
• visible-false
• editable-true
• editable-false
• set-text-colour
• set-fg-colour
• set-bg-colour

Default Value

ARGUMENT

Value(s)

Default Value

COLOUR

If the condition action is to set a colour, this colour is used. The colour may be specified in text for a limited number of colours, but it is safer to specify it in #RRGGBB format.

If no colour is set, the action will restore original colour of the target instead.

Value(s)

Default Value

CONVERT

Before running the compare 'operation' against 'value' you can convert something to a variable and use that for comparing. Convert can be normal (default), strlen or numtuples. More functions will be added in the future (check with dtd %valid_condconv_req). This function is useful when you want to create conditions on number of records or required string length.

Value(s)

• normal
• strlen
• numtuples
• numrow
• fromcash

Default Value

FORCE_NUMERIC_EVALUATION

Value(s)

• true
• false

Default Value

OPR

Operation is similar to what you would find in a SQL statement. You can specify a type of compare operation to do like equal/not equal/greater than etc. Check the dtd for more details.

Value(s)

• equal
• notequal
• greater
• less
• lessequal
• greaterequal
• null
• isnull
• notnull
• istrue
• isfalse

Default Value

REVERSE_IF_FALSE

Normally when a condition is run, it only performs the action if the condition is met. If the reverse_if_false property is set to true, the opposite action is performed if the condition is not met.

Value(s)

• true
• false

Default Value

SOURCEDBOBJECTSRC

Name of the dbobject which the condition will retrieve values from.

Value(s)

Default Value

SOURCEFIELD

Value(s)

Default Value

SOURCETABLE

Name of the table that the sourcefield belongs to; only necessary if the dbobject has more than one field of the same name.

Value(s)

Default Value

SOURCEWIDGET

Name of the widget from which the condition value should be taken. Note that it is possible to take values from database objects directly, see sourcefield, sourcetable and sourcedbobjectsrc below.

If sourcewidget and srcdbobjectsrc are not specified, but targetwidget is, then sourcewidget will default to the widget containing the condition.

Value(s)

Default Value

TARGETWIDGET

Name of the widget which should be affected by the condition. Note that if the target widget is not specified, this will default to the widget containing the condition.

Value(s)

Default Value

VALUE

This is a numerical or string value to compare using the 'opr' operation. It should not be set if you are doing a null or not null operation.

Value(s)

Default Value