Control Number

6 Control Number

Control Number

The QUERY control number is specified in the data base schema and is used by QUERY to determine whether an item may be modified and to determine the list format for the item.

Option	Choice	Value
Write Inhibit	No Inhibit Write Inhibit	0 1
Item Type	Default Date type Currency Type Undefined Type	0 2 4 6
Numeric Spacing	Default Comma Every 3 Digits	0 8
Digits Right Of Decimal Point	Default 0 digits 1 digits 2 digits 3 digits 4 digits 5 digits 6 digits	0 16 32 48 64 80 96 112

To find the control number, one value from each option is selected and the values are summed.

For example the data base item TEST-HOURS may be specified as:
2 Digits Right Of Decimal Point +48
Comma Every 3 Digits +8
Default Type +0
QUERY Write Inhibit +1
Control Number 57

Then in the schema this item is: TEST_HOURS L(57);

WRITE INHIBIT specifies whether or not an operator can make changes to this data item using QUERY-

ITEM TYPE specifies a particular format.

Date Type - The data item values are input and output as MM/DD/YY, (or DD/MM/YY in the UK and Australia), but are stored differently (refer to next Chapter).
Currency Type - The data item values are output with a preceding dollar sign, $XXXX. The UK currency is preceded with a pound sign.
Undefined Type - QUERY ignores the spacing and digits specification for this data item.

Numeric Spacing specifies whether or not commas are inserted when the data item values are output. If commas are specified, they are output after every third digit, counting from the decimal point to the left, x,xxx,xxx.

Digits Right of Decimal Point specifies the number of digits to the right of decimal point to be output. If 5 digits are specified, the number 3.45 is output as 3.45000, and the number 3.451236 is output as 3.45124.

Eloquence Query Manual - 19 DEC 2002

2 Digits Right Of Decimal Point	+48
Comma Every 3 Digits	+8
Default Type	+0
QUERY Write Inhibit	+1
Control Number	57