Skip to main content

ACCESS

Returns information about the current MultiValue file called from a dictionary.

Synopsis

ACCESS(code)

Arguments

code A literal integer value in the range 1 through 11 (inclusive). You cannot specify code as an expression. A code value containing a fractional portion is truncated to an integer. A code value outside of the range 1 through 11 generates a syntax error.

Description

The ACCESS function returns information about the current Item being processed in CMQL when the routine is called from a DICTIONARY CALL conversion code. The called routine is called for every value in the DICT item attributes. If specified in DICT item attribute 7, the routine is also called each time a break-on occurs.

The information returned by ACCESS depends on the value of code. The following code values are supported:

1 The filevar for the data portion of the file. A filevar is assigned by the OPEN statement.
2 The filevar for the dictionary portion of the file. A dictionary filevar is assigned by the OPEN statement using the DICT keyword.
3 A dynamic array containing the current item from the file.
4 Counter of the number of items processed. Defaults to 0.
5 The attribute number specified in attribute 2 of the DICT item that is calling the current routine. Defaults to 0.
6 The current value number being processed. (1 is returned for single valued attributes.) Defaults to 0.
7 The current subvalue number being processed. (1 is returned if there are no subvalues.) Defaults to 0.
8 Number of detail lines processed since the last break. (This code is only valid if the DICT item attribute 7 is specified.) Defaults to 0.
9 The current break level. Set to 0 when processing a detail line. (This code is only valid if the DICT item attribute 7 is specified.) Defaults to 0.
10 Item ID.
11 File name.

ACCESS is provided for compatibility with the D3 (PICK) implementation of MultiValue Basic.

See Also

FeedbackOpens in a new tab