Share via


Array Manipulation

These commands and functions make it possible for you to work with arrays of variables.

To

Use

ACOPY( ) Function

Copies elements from one array to another array.

ADEL( ) Function

Deletes an element from a one-dimensional array, or a row or column from a two-dimensional array.

ADIR( ) Function

Places information about files into an array and then returns the number of files.

AELEMENT( ) Function

Returns the number of an array element from the element's subscripts.

AFIELDS( ) Function

Retrieves and stores information about the structure of the table in a specified work area, specified by a table alias, or in the currently selected work area in an array and returns the number of fields in the table. 

AFONT( ) Function

Places information about available fonts, such as their names, into an array. 

AINS( ) Function

Inserts an element into a one-dimensional array, or a row or column into a two-dimensional array. 

ALEN( ) Function

Returns the number of elements, rows, or columns in an array. 

APPEND FROM ARRAY Command

Adds one record to the currently selected table for each row in an array and fills each record with data from the corresponding array row. 

ASESSIONS( ) Function

Creates an array of existing data session IDs. 

ASCAN( ) Function

Searches an array for an element containing the same data and data type as an expression. 

ASORT( ) Function

Sorts elements in an array in ascending or descending order. 

ASUBSCRIPT( ) Function

Returns the row or column subscript of an element from the element's number. 

COPY TO ARRAY Command

Copies data from the currently selected table to an array.

DECLARE Command

Creates a one- or two-dimensional array. 

DIMENSION Command

Creates a one-dimensional or two-dimensional array of variables. 

GATHER Command

Replaces the data in the current record of the currently selected table with data from an array, a set of variables, or an object. 

SCATTER Command

Copies data from the current record to a set of variables or to an array.  

See Also

Other Resources

Programming

Language Categories