Creating Arrays

version 2004 (Modified)

You create an array with one of the array declaration commands described in this chapter. The following table lists the array declaration commands:

Each array declaration command can create or resize one-dimensional or two-dimensional arrays. For more information about two-dimensional arrays, see the section Two-dimensional Arrays.

(*) Longint arrays allows you to manipulate data of Time type. To display a Time array in a form, apply to the associated form object the display format &/x, in which x represents the number of the format in the Time formats list (by order of appearance). For example, &/4 will display the Hour Min format.

(**) The difference between Text arrays and String arrays lies in the nature of their elements. In both types of array, elements can hold text values (characters). However:

• In a Text array, each element is of variable length and stores its characters in a separate part of memory.

• In a String array, all elements have the same fixed length (the length passed when the array was created). All elements are stored one after the other in the same part of memory, no matter what the contents.

Due to this structural difference, string arrays act faster than text arrays. Note, however, that an element of a String array can only hold up to 255 characters.

The following line of code creates (declares) an Integer array of 10 elements:

   ARRAY INTEGER(aiAnArray;10)

Then, the following code resizes that same array to 20 elements:

   ARRAY INTEGER(aiAnArray;20)

Then, the following code resizes that same array to no elements:

   ARRAY INTEGER(aiAnArray;0)

You reference the elements in an array by using curly braces ({…}). A number is used within the braces to address a particular element; this number is called the element number. The following lines put five names into the array called atNames and then display them in alert windows:

   ARRAY TEXT (atNames;5)
   atNames{1} := "Richard"
   atNames{2} := "Sarah"
   atNames{3} := "Sam"
   atNames{4} := "Jane"
   atNames{5} := "John"
   For ($vlElem;1;5)
      ALERT ("The element #"+String($vlElem)+" is equal to: "+atNames{$vlElem})
   End for

Note the syntax atNames{$vlElem}. Rather than specifying a numeric literal such as atNames{3}, you can use a numeric variable to indicate which element of an array you are addressing.

Using the iteration provided by a loop structure (For...End for, Repeat...Until or While...End while), compact pieces of code can address all or part of the elements in an array.

There are other 4D commands that can create and work with arrays. More particularly:

• To work with arrays and selection of records, use the commands SELECTION RANGE TO ARRAY, SELECTION TO ARRAY, ARRAY TO SELECTION and DISTINCT VALUES.

• Objects of the List box type are based on arrays; several commands of the "List box" theme work with arrays, for instance INSERT LISTBOX ROW.

• You can create graphs and charts on series of values stored in tables, subtables, and arrays. For more information, see the GRAPH command.

• Although version 6 brings a full set of new commands to work with hierarchical lists, the commands LIST TO ARRAY and ARRAY TO LIST (from the previous version) have been retained for compatibility.

• Many commands can build arrays in one call, for example: FONT LIST, WINDOW LIST, VOLUME LIST, FOLDER LIST, DOCUMENT LIST, GET SERIAL PORT MAPPING, SAX GET XML ELEMENT, etc.

ARRAY BOOLEAN, ARRAY DATE, ARRAY INTEGER, ARRAY LONGINT, ARRAY PICTURE, ARRAY POINTER, ARRAY REAL, ARRAY STRING, ARRAY TEXT, Arrays, Two-dimensional Arrays.