BOOLEAN ARRAY FROM SET

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 6.5


BOOLEAN ARRAY FROM SET (booleanArr{; set})

ParameterTypeDescription
booleanArrBoolean ArrayArray to indicate if a record is in the set or not
setStringName of the set or
UserSet if this parameter is omitted

Description

The BOOLEAN ARRAY FROM SET command fills an array of booleans indicating if each record in the table is or is not in set.

The elements in the array are ordered in the order in which the records are created in the table (absolute record numbers). If N is the number of records in the table, element 0 of the array corresponds to record number 0, element 1 of the array corresponds to record number 1, etc.

Each element of the array is:

True if the corresponding record belongs to the set.

False if the corresponding record does not belong to the set.

Warning: The total number of elements in the booleanArr array is not significant. For structural reasons, this number can be different from the number of records actually present in the table. Possible extra elements are set to False.

If you don't pass the set parameter, the command will use UserSet in the current process.

See Also

CREATE SET FROM ARRAY.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next