SQL Data Query I/O Addressing
Input tags using the SQL query driver should use the following format in their address fields:
HIST:ID/Table
Where:
HIST: - An optional prefix on the address to force the driver to configure the data returned from the database in a format that is compatible with the "History Address" settings for the analog status and digital status tags. This format is typically used when retrieving logged historical records from a database into the VTScada historian.
ID - Denotes a text string or numeric value that will uniquely identify the tag to which it is associated. This is used to match data returned from the database with the tag.
/Table - The optional table name.
Examples of valid addresses:
| Address | Description |
|---|---|
| AIT09876 | Simple text ID (In the driver configuration, select 'Single quotes should be specified on addresses') |
| 9087 | Simple numeric ID |
| PIT9087.PV/DataLog | ID "PIT9087.PV" including a table named "DataLog". |
| HIST:PIT9087.PV/DataLog | ID "PIT9087.PV" including a table named "DataLog" used in history retrieval mode |
| HIST:9087 | ID "9087" used in history retrieval mode |
