|
|
|
|
|
- Formatting the result
- Use in HFSQL stored procedures
SQLCode (Property) In french: CodeSQL
The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). The comments entered in the query editor are visible in the SQL code.
MonCodeSQL is string
MonCodeSQL = REQ_RequêteCalcul.CodeSQL
Syntax
Getting the SQL code of a query Hide the details
<SQL code> = <Query used>.SQLCode
<SQL code>: Character string SQL code of the specified query. If the ".WDR" file contains comments, they will appear in the SQL code of the query (comments start with "--"). <Query used>: Query name Logical name of the query used. This name is defined in the query editor. Remarks Formatting the result The query's SQL code is identical to that displayed in the query editor via the "SQL Code" option in the query's context menu: spaces, tabs and line breaks are retained. Use in HFSQL stored procedures The SQLCode property can be used in the code of a stored procedure to get the code of a stored query on the server.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|