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
-
Get last query path
| Get last query path ( descFormat ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| descFormat | Longint |
|
Description format (Text or XML) | |||||
| Function result | String |
|
Description of last executed query path | |||||
The Get last query path command returns the detailed internal description of the actual path of the last query carried out on the data. For more information about query descriptions, please refer to the documentation of the DESCRIBE QUERY EXECUTION command.
This description is returned in Text or XML format depending on the value passed in the descFormat parameter. You can pass one of the following constants, found in the “Queries” theme:
| Constant | Type | Value |
| Description in text format | Longint | 0 |
| Description in XML format | Longint | 1 |
This command returns a significant value if the DESCRIBE QUERY EXECUTION command has been executed during the session.
The description of the last query path can be compared to the description of the query plan provided for the last query (obtained using the Get last query plan command) for optimization purposes.
Product: 4D
Theme: Queries
Number:
1045
Created: 4D v11 SQL Release 1
4D Language Reference ( 4D v20)
4D Language Reference ( 4D v20.1)
4D Language Reference ( 4D v20.2)
4D Language Reference ( 4D v20.3)
4D Language Reference ( 4D v20.4)
4D Language Reference ( 4D v20.5)
4D Language Reference ( 4D v20.6)
