4D v14.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 EXAMPLE
- QUERY BY FORMULA
- QUERY SELECTION
- QUERY SELECTION BY FORMULA
- QUERY SELECTION WITH ARRAY
- QUERY WITH ARRAY
- SET QUERY AND LOCK
- SET QUERY DESTINATION
- SET QUERY LIMIT
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 command QUERY BY FORMULA.
Product: 4D
Theme: Queries
Number:
207
Modified: 4D v11 SQL Release 2
QUERY
QUERY BY FORMULA
QUERY SELECTION
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)
