Character and size limits in ACL

There are limits to certain input ranges and user-defined parameters in ACL. The following tables define these limits and explain the results when you exceed them.

Project limits

Parameter

Limit

Result when limit exceeded

Maximum length of an ACL project path and name

254 characters

Includes the file path, project name, and file extension (.acl)

ACL stops working

Table limits

Parameter

Limit

Result when limit exceeded

Maximum length of a table layout name

31 characters

Truncation to 31 characters

Maximum length of a field name

31 characters

Truncation to 31 characters

Valid characters in a table layout name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ ).

Valid characters in a field name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ )

Maximum record length

32767 bytes

ACL resets to 32767

Maximum field length

32767 bytes

Error message

Maximum number of decimal places in a numeric field

22

Error message

Maximum length of a source data file path and name

255 characters

ACL stops working

View limits

Parameter

Limit

Result when limit exceeded

Maximum length of a view name

31 characters

Truncation to 31 characters

Valid characters in a view name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ )

Maximum width of a column in a view

255 characters

Error message

Columns can temporarily be extended beyond 255 characters by dragging the column boundary in the view, but will be reset in the Modify Columns dialog box

Maximum number of columns in a view

1023 columns and a total number of characters in the column titles < 1KB

Error message

Maximum number of characters in an Alternate Column Title name

150 characters

Error message when reopening the view, and truncation to 150 characters

Filter limits

Parameter

Limit

Result when limit exceeded

Maximum length of a filter name

31 characters

Error message

Valid characters in a filter name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ )

Index limits

Parameter

Limit

Result when limit exceeded

Maximum length of index key field

247 bytes

Error message

Maximum number of index key fields

247 bytes total length

Error message

Expression limits

Parameter

Limit

Result when limit exceeded

Maximum number of characters in an expression

1023 characters

Error message

Maximum number of characters in an IF condition

1023 characters

Error message

Maximum number of characters in an individual Condition or Value

255 characters

Error message and resets to 255

Variable limits

Parameter

Limit

Result when limit exceeded

Maximum length of a variable name

31 characters

Error message

Valid characters in a variable name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ ), or error message

Script limits

Parameter

Limit

Result when limit exceeded

Maximum length of a script name

31 characters

Truncation to 31 characters

Valid characters in a script name

Alphanumeric characters, and the underscore character ( _ )

The name cannot contain any spaces or start with a number

Replacement of an invalid character with an underscore character ( _ )

Date limits

Parameter

Limit

Result when limit exceeded

Range of supported dates

1 Jan 1900 to 31 Dec 9999 (inclusive)

Error message

Dialog Builder limits

Parameter

Limit

Result when limit exceeded

Maximum number of Drop-down list options

32 list items

Will not accept additional text beyond 32 items in the Label List

Maximum size of a single Drop-down Item Label

255 characters

Truncated to 255 characters

Option dialog box limits

Parameter

Limit

Result when limit exceeded

Maximum Buffer Size

255 KB

Error message



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