Skip to content

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 


 

Feedback and Knowledge Base