4D v14.3

Get last query path

Home

 
4D v14.3
Get last query path

Get last query path 


 

Get last query path ( descFormat ) -> Function result 
Parameter Type   Description
descFormat  Longint in Description format (Text or XML)
Function result  String in 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.

 
PROPERTIES 

Product: 4D
Theme: Queries
Number: 1045

 
HISTORY 

Created: 4D v11 SQL Release 1

 
SEE ALSO 

DESCRIBE QUERY EXECUTION
Get last query plan

 
ARTICLE USAGE

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)