dbLabelQuery (dbCONNECT)
Compatible with:
- Purpose
- This command is used to "label" a SQL query in the context of a particular dbBlock.
- Once used, you can refer to the SQL query within the current dbBlock using that label (instead of using the SQL query itself).
- The SQL query could have variables (as placeholders) which then could be populated (replaced/filled) using the dbSetQueryValue command that follows this command but before the dbExecuteQuery command within the current dbBlock.
- The variables within the SQL Query have to be of the format ${variableName}.
- Syntax
- dbLabelQuery(query,label)
- Target
- SQL Query.
- Only CRUD SQL statements are supported. In other words, your queries must start with a Select, Insert, Update or Delete.
- Value
- labelName
- Return Value
- N/A
Example(s):
Click here to see the example