[ |../../index.htm#lansa/l4wtgu03_0475.htm]
You are here:

S/O Range

This must be specified if the Select/Omit Type is Range.
Range From
Mandatory.
Specify the lower value that the select/omit column should be compared to.
Rules
Allowable values are:

• Character literal in quotes (e.g. 'BALMAIN').
• Numeric literal (e.g.  1.54).
• DateTime literal in quotes. (e.g. '2005-05-01 10:00:00') DateTime literals need to be entered as per the SUTC attribute of the field. If the SUTC attribute is enabled, enter the value as UTC, otherwise enter the value in local time.
• Name of another column in the table definition.

S/O Range To
Mandatory.
Rules
Allowable values are:

• Character literal in quotes (e.g. 'BALMAIN').
• Numeric literal (e.g.  1.54).
• DateTime literal in quotes. (e.g. '2005-05-01 10:00:00') DateTime literals need to be entered as per the SUTC attribute of the field. If the SUTC attribute is enabled, enter the value as UTC., otherwise enter the value in local time.
• Name of another column in the table definition.

[ |../../index.htm#lansa/l4wtgu03_0475.htm]