Skip to end of metadata
Go to start of metadata

This function is used by Ignition's Expression language.

Description

This function is only available in Transaction Group Expression Items and Expression Tags.

Executes a select query using the given ConnectionName (or the default connection it omitted) and stores the result into a global ResultSetName.

Syntax

executeQuery(query, resultName[, datasource])

  • Parameter

string query - The query to execute.

string resultName - The name of the global result set.

string datasource - Optional. The name of the database connection.

  • Results

int - The number of rows in the returned table.

Examples
Code Snippet
executeQuery("SELECT * FROM table", "MyResult", "MySQLConnection") //would store the results in "MyResult" and return an integer based on how many rows were in the table.
  • No labels