Processing Codes

The a processing code is a recursive algebraic function that creates algebraic formulas and relational operations consis

The b processing code maintains a horizontal relationship (bridge) between an attribute in one item and an item in anoth

The c processing code concatenates elements for output.

The c processing code defines the controlling attribute in a controlling/dependent pair of attributes when placed in att

The call processing code calls a BASIC or FlashBASIC subroutine from the file-defining item or an ADI. Called subroutine

The callc (close trigger) is called before the table is closed.

The calld (delete file trigger) is called before the file is deleted.

The calle (clear file trigger) is called before the file is cleared.

For Windows (FSI): The callo (open trigger) is called after a table has successfully been opened.

The callr (read trigger) is called when a record is read from the table.

The callx processing code is called when a record is updated in the table.

The cu processing code allows data in a defined attribute with an output-conversion (attribute 7) or correlative (attrib

The d processing code invokes the date conversion function to convert an external date to internal format, or more commo

The d processing code defines the dependent attribute in a control/dependent pair of correlated MultiValues; the control

The encrypt processing code is field-level encryption functionality that works with the encrypt-file and decrypt-file co

The f-correlative is used in the conversion (attribute 7), correlative (attribute 8), and input-conversion (attribute 14

The g processing code extracts one or more groups of contiguous character substrings delimited by the specified characte

The i processing code is stored in the correlative (attribute 8) of the file-defining items to maintain index keys. The

The i processing code indicates that an index exists for the current attribute. It must be defined in the attribute-defi

The i processing code is used as an input-conversion (attribute 14) and indicates that this attribute is based on data i

The id processing code is used by the Update processor to create new item-IDs. Originally implemented for the Update Pro

The if processing code is used in dictionary attributes 7 and 8 (conversion and correlative) to generate values based on

The l processing code either restricts processing to values that fall within certain length restrictions or displays the

The m processing code is a masking conversion used for both numeric and text string formatting. This conversion is quite

The mc processing code invokes one of many available processing codes available for special processing on numeric and al

The mi processing code is used as an input-conversion code (attribute 14) and prohibits filing an item if any attribute

The mp processing code is used for converting a value to a packed decimal value or a packed decimal value to a value.

The ms processing code alters the normal sort sequence of characters.

The mt processing code invokes the time conversion function to convert external time representations to internal format

The mx processing code converts all ASCII characters in a given value to their corresponding ASCII-hexadecimal equivalen

The my processing code converts all ASCII hexadecimal characters in a given value to their corresponding ASCII equivalen

The o processing code sorts the values in the specified attributes in ascending order. The values are sorted when the it

The p processing code tests a value and determines if it matches a predetermined pattern matchstring composed of alphabe

This section discusses processing codes.

The following processing codes are available.

Processing codes describe database links and data manipulation rules in dictionaries. The D3 dictionary defines file lay

The r processing code invokes the range function, and restricts processing to those values that fall within given minimu

The s (Subindex) processing code is used to update an index that uses a file translation if the value in the translate f

The s processing code substitutes either a data value from the referenced attribute or literal text when the current dat

The t processing code provides a facility for extracting any number of characters from an attribute, starting at the pos

The t processing code uses the presented value as an item-ID and attempts to retrieve the corresponding item in another

AQL user exits allow direct access to system functions.

The v processing code specifies the maximum number of values allowed in an attribute when as an input-conversion (attrib

The v processing code is used by the within connective and must be placed in the correlative attribute 8 of the file-def

The x processing code is used as an input-conversion (attribute 14) and indicates that the specified attribute is for di

The x processing code is placed in the correlative of a file-defining item to provide an audit trail for items that are

The xc processing code centers the input string in a field of spaces.

The xi processing code forces any further conversions to be treated as input-conversions.

The xo processing code forces any further conversions to be treated as output-conversions.

The xr processing code produces a running subtotal of an output column on an AQL listing or report.

The xt processing code toggles the conversion direction from an input to an output-conversion or vice-versa.

The y processing code stamps user, PIB, and/or time/date update information into an internal item header from all proces

The za processing code displays a D3 item in a format compatible with assembly source code.

The zc processing code uses the zcf file to display the city, state, and Zip code. For international zip codes, an addit