Contents
Partner Programs
Sepasoft - MES Modules
Cirrus Link - MQTT Modules
Resources
Knowledge Base Articles
Inductive University
Forum
IA Support
SDK Documentation
All Manual Versions
Ignition 8.0
Ignition 7.9
Ignition 7.8
This feature was removed from Ignition in version 8.0.0
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.
executeUpdateQuery(query[, connectionName])
string query - The query to execute.
string connectionName - Optional. The name of the database connection.
int - The number of rows affected.
executeUpdateQuery(query, [ConnectionName])
executeUpdateQuery("UPDATE table SET columnName1 = 15.89 WHERE index = 4", "MySQLConnection") //would return a 1 and update the table.