|
SQLTag References are used just like OPC Items, adding the convenience of using a SQLTag that has already been set up with scaling and alarm data.
SQLTag Reference Properties
General:
| • | Tag Path - The path to the tag being referenced. This value is not editable except by clicking the Insert Tag button. There cannot be duplicate names within a group. |
| • | Data Type - The datatype to write to into the database if this item is not read-only. |
| • | Property - Which property of the SQLTag you want to use. |
| 2) | Quality - Quality code of the SQLTag (192 = GOOD_DATA) |
| 3) | Timestamp - The last time the item value changed |
| 4) | Name - The SQLBridge Item Name property of this Item. |
| • | Mode - Options for displaying values based on the Item value. |
| 1) | Direct Value - Item value |
| 2) | Hour Meter - Record the amount of time the Item value is non-zero. This accumulation will reset to zero when the item value goes to zero. The datatype should be set to integer or float when using an Hour Meter regardless of the OPC Item type. |
| • | On Zero - Use a zero value to accumulate time instead of a non-zero value |
| • | Retentive - Retain the Hour Meter value when it is not accumulating. |
| • | Units - The time units to display. |
| 3) | Event Meter - Record the number or times the Item value is non-zero. The datatype should be set to integer when using an Event Meter regardless of the OPC Item type. |
| • | On Zero - Use a zero value to accumulate events instead of a non-zero value |
| • | Mode - Changes the items directional read/write option. This is only editable when the target Type is set to Database field. |
| 1) | Use group's mode - Inherit the Update Mode from the Item's Group. |
| 2) | OPC to DB - Only read from the OPC server and write to the database. |
| 3) | DB to OPC - Only read from the database and write to the OPC Server. |
| 4) | Bi-directional OPC wins - Read and Write to both the database and OPC Server. On group start, write OPC Server values to the database. |
| 5) | Bi-directional DB wins - Read and Write to both the database and OPC Server. On group start, write database values to the database. |
| • | Target Type - This is the selection for what the Item will write to when the group executes. |
| 1) | None, read-only item - Do not write this value to the database. |
| 2) | Database field - Write the Item value to the specified column in the database table. |
| • | Target Name - The name of the column in the database that this Item will write to when the group executes. The Target Name list will populate with all the column names from the Group's target table if the Target Type is Database field. |
|