Options dialog box: Numeric tab

You can use the options in the Numeric tab to specify how ACL processes and displays numeric data.

Stop on Numeric Overflow

When you select this option, ACL stops processing when a numeric overflow occurs. If the results of mathematical operations, including intermediate calculations, exceed 22 digits, ACL may stop processing. In the view, affected fields display ###ERR###.

When you turn this option off, ACL continues to process, but it truncates excess digits, starting from the left, which produces inaccurate calculations. When the user attempts division by zero, ACL substitutes a large number for the result.

Changes to this setting are recorded in the log using the following syntax:

SET OVERFLOW {ON|OFF}

Verify Data

If you turn this option on, every time you process a field while a table is open, ACL automatically checks whether the contents of a data field correspond to the field’s data type in the table layout (Character, Numeric, Datetime, Logical, etc.). Processing stops when an error occurs, unless the Blank Invalid Data option is also on.

If you turn this option off, ACL does not test for data validity, therefore improving processing speed.

Changes to this setting are recorded in the log using the following syntax:

SET VERIFY {ON|OFF}

Blank Invalid Data

This option is only available when the Verify Data option is turned on. If you turn Blank Invalid Data on, ACL automatically replaces invalid character data with blanks and invalid numeric data with zeros.

If you enable this option and process a field that contains invalid data, ACL creates an error log in the same folder as your ACL project files and displays the message: “Invalid data encountered in file, values zeroed. See file ERROR.LOG”. To view or print the log, you can use a word processor or text editor to open it in the directory in which you store your working files. You can access the error log while in ACL, by using the Type or Dump commands.

Changes to this setting are recorded in the log using the following syntax, where BLANK indicates that the option is selected and ON means that the Verify Data option is selected, but Blank Invalid Data is not:

SET VERIFY (BLANK|ON}

Expression Field Width

This option indicates the default display width for numeric computed fields or ad hoc numeric expressions, for which ACL cannot determine the maximum width. The default is 12 characters, based on ACL’s default application font.

Changes to this setting are recorded in the log using the following syntax:

SET WIDTH value

Decimal Place Symbol

ACL uses a period as the default decimal place character. To change the default setting, enter a new character in the text box.

Changes to this setting are recorded in the log as a change to the Default Numeric Format.

Default Numeric Format

By default, ACL displays numbers using a numeric format that does not use thousands separators and denotes negative numbers with a leading minus sign.

You can modify the Default Numeric Format option to display numeric values using a different format. You can select one of the predefined formats from the drop-down list, or create a format of your own. The format you choose should be generic because it is applied to all numeric values in ACL, unless a more specific format is supplied in the table layout or view. For example, you may want to create a format that specifies a thousands separator and a different indicator for negative numbers, but you should not specify a currency sign because you will need to specify a different format for any numeric value that is not a monetary value in the table layout or view.

Changes to this setting are recorded in the log using the following syntax:

SET PICTURE format

Thousands Separator

ACL uses a comma as the default thousands separator for numeric output. To change the default setting, enter a new character in the text box.

Changes to this setting are recorded in the log as a change to the Default Numeric Format.

List Separator

ACL uses a comma as the default list separator, which is used primarily to separate function parameters. To change the default setting, enter any character, other than the one you used for the decimal place character, in the text box.

Related concepts
Numeric value formatting
Related tasks
Configuring ACL options


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback