4D v13.4
QUERY SELECTION BY FORMULA
- 4D Language Reference
-
- Queries
-
- DESCRIBE QUERY EXECUTION
- Find in field
- Get last query path
- Get last query plan
- GET QUERY DESTINATIONNew
- Get query limitNew
- 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 DESTINATIONUpd
- SET QUERY LIMIT
4D v13.4
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 command QUERY BY FORMULA.
PROPERTIES
Product: 4D
Theme: Queries
Number:
207
INDEX
HISTORY
Modified: 4D v11 SQL Release 2
SEE ALSO
QUERY
QUERY BY FORMULA
QUERY SELECTION
© 1985-2013 4D SAS / 4D, Inc. All rights reserved.