Skip to main content
Version: 20 R7

Arrays

APPEND TO ARRAY ( array ; value )
ARRAY BLOB ( arrayName ; size {; size2} )
ARRAY BOOLEAN ( arrayName ; size {; size2} )
ARRAY DATE ( arrayName ; size {; size2} )
ARRAY INTEGER ( arrayName ; size {; size2} )
ARRAY LONGINT ( arrayName ; size {; size2} )
ARRAY OBJECT ( arrayName ; size {; size2} )
ARRAY PICTURE ( arrayName ; size {; size2} )
ARRAY POINTER ( arrayName ; size {; size2} )
ARRAY REAL ( arrayName ; size {; size2} )
ARRAY TEXT ( arrayName ; size {; size2} )
ARRAY TIME ( arrayName ; size {; size2} )
ARRAY TO LIST ( array ; list {; itemRefs} )
ARRAY TO SELECTION {( array ; aField {; array2 ; aField2 ; ... ; arrayN ; aFieldN}{; *} )}
BOOLEAN ARRAY FROM SET ( booleanArr {; set} )
COPY ARRAY ( source ; destination )
Count in array ( array ; value ) : Integer
DELETE FROM ARRAY ( array ; where {; howMany} )
DISTINCT ATTRIBUTE PATHS ( objectField ; pathArray )
DISTINCT ATTRIBUTE VALUES ( objectField ; path ; valuesArray )
DISTINCT VALUES ( aField ; array {; countArray} )
Find in array ( array ; value {; start} ) : Integer
Find in sorted array ( array ; value ; > or < {; posFirst {; posLast}} ) : Boolean
INSERT IN ARRAY ( array ; where {; howMany} )
LIST TO ARRAY ( list ; array {; itemRefs} )
LONGINT ARRAY FROM SELECTION ( aTable ; recordArray {; selection} )
MULTI SORT ARRAY ( array {; sort}{; array2 ; sort2 ; ... ; arrayN ; sortN} ) 
MULTI SORT ARRAY ( ptrArrayName ; sortArrayName )

SELECTION RANGE TO ARRAY ( start ; end ; aField ; array} {; aField2 ; array2 ; ... ; aFieldN ; arrayN} )
SELECTION RANGE TO ARRAY ( start ; end ; aTable ; array {; aTable2 ; array2 ; ... ; aTableN ; arrayN} )

SELECTION TO ARRAY {( aField ; array {; aField2 ; array2 ; ... ; aFieldN ; arrayN}{; *})
SELECTION TO ARRAY {( aTable ; array {; aField ; array {; aField2 ; array2 ; ... ; aFieldN ; arrayN}}{; *})}

Size of array ( array ) : Integer
SORT ARRAY ( array {; array2 ; ... ; arrayN}{; > or <} )
TEXT TO ARRAY ( varText ; arrText ; width ; fontName ; fontSize {; fontStyle {; *}} )