QUERY SELECTION WITH 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

version 11.2


QUERY SELECTION WITH ARRAY (targetField; array)

ParameterTypeDescription
targetFieldFieldField used to compare the values
arrayArrayArray of searched values

Description

The QUERY SELECTION WITH ARRAY command searches the table of the field passed as first parameter for the records where the value of targetField is equal to at least one of the values of the elements in the array. The records found will become the new current selection.

QUERY SELECTION WITH ARRAY functions in the same way as QUERY WITH ARRAY. The difference between these two commands is the scope of the search:

QUERY WITH ARRAY searches all the records of the table containing targetField.

QUERY SELECTION WITH ARRAY only searches the records of the current selection of the table containing targetField.

For more information, please refer to the description of the QUERY WITH ARRAY command.

See Also

QUERY WITH 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