4D v16.3SELECTION TO ARRAY |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v16.3
SELECTION TO ARRAY
SELECTION TO ARRAY
The SELECTION TO ARRAY command creates one or more arrays and copies data in the fields or record numbers from the current selection into the arrays. The command SELECTION TO ARRAY applies to the selection for the table designated by the first parameter (table name or field name). SELECTION TO ARRAY can perform the following:
Each array is typed according to the field type. When you apply SELECTION TO ARRAY to a Time type field, it is important to note that they only create a Time type array if the array has not already been defined as another type. For example, in the following context, the myArray array remains a Longint type array: ARRAY LONGINT(myArray;0) If you load record numbers, they are copied into a Long Integer array. When you pass the * parameter, 4D does not execute the corresponding statement line immediately but instead stores it in memory; this way you can stack several lines ending with an *. All of these lines awaiting execution are executed by one final SELECTION TO ARRAY statement that does not have the * parameter. For this reason, the command can now be called without any parameters. In this case, array types are verified when the final line (without the * parameter) is executed. 4D Server: The SELECTION TO ARRAY command is optimized for 4D Server. Each array is created on the server and then sent, in its entirety, to the client machine. WARNING: The SELECTION TO ARRAY command can create large arrays, depending on the size of the current selection and on the type and size of the data you are loading. Arrays reside in memory, so it is a good idea to test the result after the command is completed. To do so, test the size of each resulting array or cover the call to the command, using an ON ERR CALL project method. Note: After a call to SELECTION TO ARRAY, the current selection and current record remain the same, but the current record is no longer loaded. If you need to use the values of the fields in the current record, use the LOAD RECORD command after the SELECTION TO ARRAY command. In the following example, the [People] table has an automatic relation to the [Company] table. The two arrays asLastName and asCompanyAddr are sized according to the number of records selected in the [People] table and will contain information from both tables: SELECTION TO ARRAY([People]Last Name;asLastName;[Company]Address;asCompanyAddr) The following example returns the [Clients] record numbers in the array alRecordNumbers and the [Clients]Names field values in the array asNames: SELECTION TO ARRAY([Clients];alRecordNumbers;[Clients]Names;asNames) The same example can be written: SELECTION TO ARRAY([Clients];alRecordNumbers;*)
See also
ARRAY TO SELECTION
|
PROPERTIES
Product: 4D HISTORY
Created: < 4D v6 ARTICLE USAGE
4D Language Reference ( 4D v16) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||