Skip to main content
Version: 7.9

executeUpdateQuery

This function is used by Ignition's Expression language.

Description

note

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.

Examples

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