Commands and Topics for Arrays
Arrays
Creating Arrays
Arrays and Form Objects
Grouped Scrollable Areas
Arrays and the 4D Language
Arrays and Pointers
Using the element zero of an array
Two-dimensional Arrays
Arrays and Memory
ARRAY INTEGER
(arrayName; size{; size2})
ARRAY LONGINT
(arrayName; size{; size2})
ARRAY REAL
(arrayName; size{; size2})
ARRAY STRING
(strLen; arrayName; size{; size2})
ARRAY TEXT
(arrayName; size{; size2})
ARRAY DATE
(arrayName; size{; size2})
ARRAY BOOLEAN
(arrayName; size{; size2})
ARRAY PICTURE
(arrayName; size{; size2})
ARRAY POINTER
(arrayName; size{; size2})
Size of array
(array)
Number
SORT ARRAY
(array{; array2; ...; arrayN}{; > or <})
MULTI SORT ARRAY
(array{; sort}{; array2; sort2; ...; arrayN; sortN})
Find in array
(array; value{; start})
Number
Count in array
(array; value)
Longint
INSERT ELEMENT
(array; where{; howMany})
DELETE ELEMENT
(array; where{; howMany})
APPEND TO ARRAY
(array; value)
COPY ARRAY
(source; destination)
LIST TO ARRAY
(list; array{; itemRefs})
ARRAY TO LIST
(array; list{; itemRefs})
SELECTION TO ARRAY
(field | table; array{; field2 | table2; array2; ...; fieldN | tableN; arrayN})
SELECTION RANGE TO ARRAY
(start; end; field | table; array{; field2 | table2; array2; ...; fieldN | tableN; arrayN})
ARRAY TO SELECTION
(array; field{; array2; field2; ...; arrayN; fieldN})
DISTINCT VALUES
(field; array)
LONGINT ARRAY FROM SELECTION
(table; recordArray{; selection})
BOOLEAN ARRAY FROM SET
(booleanArr{; set})
Other related commands:
Load list
(listName)
ListRef --
Theme:
Hierarchical Lists
SAVE LIST
(list; listName) --
Theme:
Hierarchical Lists
ON ERR CALL
(errorMethod) --
Theme:
Interruptions
CREATE SELECTION FROM ARRAY
(table; recordArray{; selectionName}) --
Theme:
Named Selections
ORDER BY
({table}{; field{; > or <{; field2; > or <2; ...; fieldN; > or <N}{; *}}}) --
Theme:
Queries
QUERY WITH ARRAY
(indexedField; array) --
Theme:
Queries
SET AUTOMATIC RELATIONS
(one{; many}) --
Theme:
Relations
STRING LIST TO ARRAY
(resID; strings{; resFile}) --
Theme:
Resources
CREATE SET FROM ARRAY
(table; recordsArray{; setName}) --
Theme:
Sets
SET DATABASE PARAMETER
({table; }selector; value) --
Theme:
Structure Access