Database Expression Functions

The following functions allow you to interact with a database in expression bindings. These are only available in Transaction groups.

This feature was removed from Ignition in version 8.0.0

📄️ executeQuery

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

📄️ executeScalarQuery

Executes a select query using the given connectionName (or the default connection it omitted) and returns the first scalar value from the resultset.

📄️ executeUpdateQuery

Executes an update query using the given ConnectionName (or the default connection it omitted) and returns the number of rows effected.

📄️ getDatasetValueByIndex

Retrieves a value from a global variable DatasetName created using the ExecuteQuery function.

📄️ getDatasetValueByName

Retrieves data from a global variable DatasetName created using the ExecuteQuery function.

📄️ isDBConnectionAvailable

Checks if the given database connection is available. Will use the default for that scope if none is specified.