4D v14.3

QUERY SELECTION WITH ARRAY

Home

 
4D v14.3
QUERY SELECTION WITH ARRAY

QUERY SELECTION WITH ARRAY 


 

QUERY SELECTION WITH ARRAY ( targetField ; array ) 
Parameter Type   Description
targetField  Field in Field used to compare the values
array  Array in Array of searched values

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.

 
PROPERTIES 

Product: 4D
Theme: Queries
Number: 1050

The command changes the current selection

 
HISTORY 

Created: 4D v11 SQL Release 2

 
SEE ALSO 

QUERY WITH ARRAY

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)