The ArrayDictionary part gives row-oriented access to a set of arrays that are defined as columns; that is, you can use this part to access a series of arrays by retrieving the same-numbered element of each array. A set of elements that is retrieved in this way is itself a dictionary, with each of the original array names treated as a key that is paired with the value contained in the array element.
The ArrayDictionary part is always available; you do not define it, but simply declare a variable based on it.
ID = 5, lastName = "Twain", firstName = "Mark", age = 30
ID INT[] = [1,3,5,9]; lastName STRING[] = ["Cervantes", "Moliere", "Twain", "Tolstoy"]; firstName STRING[] = ["Miguel", "", "Mark", "Lev"]; age INT[] = [90, 29, 30, 55]; myRows ArrayDictionary { col1 = ID, col2 = lastName, col3 = firstName, col4 = age };
cell INT = myRows[2]["col1"]; cell INT = myRows[2].col1;
row Dictionary = myRows[2];
cell INT = row["col1"]; cell INT = row.col1;
EGL Console UI uses array dictionaries for screen displays where you have both rows and columns of data. For example, each row (dictionary) might represent a transaction on a point of sale terminal.
An ArrayDictionary part does not have any of the functions or properties of either an Array or a Dictionary.
Platform | Issue |
---|---|
JavaScript generation | ArrayDictionary is not supported. |