4D v16.3
QUERY SELECTION BY FORMULA
- 4D Language Reference
-
- Queries
-
- DESCRIBE QUERY EXECUTION
- Find in field
- Get last query path
- Get last query plan
- GET QUERY DESTINATION
- Get query limit
- ORDER BY
- ORDER BY FORMULA
- QUERY
- QUERY BY ATTRIBUTE
- QUERY BY EXAMPLE
- QUERY BY FORMULA
- QUERY SELECTION
- QUERY SELECTION BY ATTRIBUTENew
- QUERY SELECTION BY FORMULA
- QUERY SELECTION WITH ARRAY
- QUERY WITH ARRAY
- SET QUERY AND LOCK
- SET QUERY DESTINATION
- SET QUERY LIMIT
4D v16.3
QUERY SELECTION BY FORMULA
QUERY SELECTION BY FORMULA
| QUERY SELECTION BY FORMULA ( aTable {; queryFormula} ) | ||||||||
| Parameter | Type | Description | ||||||
| aTable | Table |
|
Table for which to return a selection of records | |||||
| queryFormula | Boolean |
|
Query formula | |||||
QUERY SELECTION BY FORMULA looks for records in aTable. QUERY SELECTION BY FORMULA changes the current selection of aTable for the current process and makes the first record of the new selection the current record.
QUERY SELECTION BY FORMULA performs the same actions as QUERY BY FORMULA. The difference between the two commands is the scope of the query:
- QUERY BY FORMULA looks for records among all the records in the table.
- QUERY SELECTION BY FORMULA looks for records among the records currently selected in the table.
For more information, see the description of the QUERY BY FORMULA command.
See also
PROPERTIES
Product: 4D
Theme: Queries
Number:
207
HISTORY
Modified: 4D v11 SQL Release 2
ARTICLE USAGE
4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)
© 1985-2018 4D SAS / 4D, Inc. All rights reserved.