|
The value of the Direction field also determines whether values are read or written to the relational database as follows: Out – Send the values of the specified block and field name pairs to the relational database. These values update existing values, are inserted in the relational database, or used in a Where clause. Typically, the number of Out fields equals the number of parameters in INSERT or UPDATE commands. In – Receive the values of the specified block and field name pairs from the relational database. Typically, the number of In fields equals the number of columns specified in the SELECT commands. For example, using the command shown below, you can add a new record in the relational database: INSERT into TBL1 (COL1, COL2, COL3) values (?, ?, ?) The direction for each value in this example is set to OUT.
|
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. |
|
|