Get Last Query Path

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11.1


Get Last Query Path (descFormat) String

ParameterTypeDescription
descFormatLongintDescription format (Text or XML)
Function resultStringDescription of last executed query path

Description

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:

ConstantTypeValue
Description in Text FormatLongint0
Description in XML Format Longint1

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.

See Also

DESCRIBE QUERY EXECUTION, Get Last Query Plan.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next