Behavior of SQL Data Blocks While Off Scan

The SQL Data block identifies the blocks that transfer to or receive data from your relational database. The block, however, does not monitor a block's status or mode. If a block is off scan, when the upstream SQL Trigger block starts, the SQL task substitutes a null value for the off-scan block's current value. If the target column in the relational database cannot accept a null value, the INSERT or UPDATE fails and the SQL Trigger block generates an alarm.  

 

Important Notice

You do not have the latest version of iFIX! You are missing out on the newest capabilities and enhanced security.

For information on all the latest features, see the iFIX product page.

For more information on upgrades, contact your GE Digital sales agent or e-mail GEDClientServices@gevernova.com.

For the most up-to-date documentation, go here.