Synchronous transaction script

The single script for this SQLData object shows how to use the synchronous SQL processing in the SQLData Script Library. This script is uses a transaction object with the command object on the transaction. For comparison, see Asynchronous command script where the example uses the command object directly on the connection, without a transaction.

This transaction object is written with a single script called QueryandProcess, which performs the SQL processing synchronously and then manipulates the results. This script runs without synchronizing with the ArchestrA AppEngine scan (asynchronous script). To use the script, set the part number to search for in the PartNumber UDA and the column whose value is to be read in the ColumnToRead UDA. Signal the script to run by setting the ReadTransaction UDA to True. When the script finishes processing, the ColumnReadDone UDA becomes True and the results are in the ColumnValue UDA.

QueryandProcess Script Configuration

On the Script tab of the SQLData Object Editor, configure the QueryandProcess script with the following attributes.