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