Sepasoft - MES Modules
Cirrus Link - MQTT Modules
Knowledge Base Articles
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 returns the first scalar value from the resultset.
string query - The query to execute.
string connectionName - Optional. The name of the database connection.
Value - The first value returned from the query.
For the following examples, suppose there was a table 'weights' that contained these values.
executeScalarQuery("SELECT MAX(Quantity) FROM weights", "MySQLConnection") //would return 380
executeScalarQuery("SELECT * FROM weights", "MySQLConnection") //would return a string "BAN_002"