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 an update query using the given ConnectionName (or the default connection it omitted) and returns the number of rows effected.

Syntax

executeUpdateQuery(query[, connectionName])

  • Parameters

string query - The query to execute.

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

  • Results

int - The number of rows affected.

Syntax

executeUpdateQuery(query, [ConnectionName])

Examples
Code Snippet
executeUpdateQuery("UPDATE table SET columnName1 = 15.89 WHERE index = 4", "MySQLConnection") //would return a 1 and update the table.