This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 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 ATTRIBUTE
-
ORDER BY FORMULA
-
QUERY
-
QUERY BY ATTRIBUTE
-
QUERY BY EXAMPLE
-
QUERY BY FORMULA
-
QUERY SELECTION
-
QUERY SELECTION BY ATTRIBUTE
-
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 QUERY BY FORMULA command.
Product: 4D
Theme: Queries
Number:
207
Modified: 4D v11 SQL Release 2
4D Language Reference ( 4D v20 R7)
