Associated with: ODBC Connections, ODBC Queries, ODBC points
The Source attribute is common to many Status displays. The attribute indicates the location at which the item resides. The information shown varies, depending on the item.
The Source attribute displays the value Undefined if the item’s configuration is incomplete, in so far as the device with which the item is associated has not yet been specified.
For ODBC Connections and ODBC Queries, information is displayed in this format:
<Data Source Name>
CRSS
(Where CRSS is the Data Source Name (DSN) of an SQL server.)
For ODBC points, the format in which information is displayed varies, depending on the look up method:
For a point that uses a Row & Column method, information is displayed in this format:
<Data Source Name>:<Row number>,<Column number>
CRSS:1,4
(For a point that is used to extract data from row 1, column 4, of the results table produced by an SQL query that is extracting data from an SQL server with the DSN ‘CRSS’.)
For a point that uses a Value Lookup method, information is displayed in this format:
<Data Source Name>:LOOKUP <Lookup Column>(<Lookup Value>).<Value Column>, <Quality Column>,<Timestamp Column>,<Use All Results>
CRSS:LOOKUP 1(5).2,0,3,All
(For a point that uses a ‘Value Lookup’ method to extract data from Lookup Column 1, Lookup Value 5, Value Column 2, Quality Column 0, and Timestamp Column 3. The source database includes historic data, and the ‘All’ attribute indicates that all matching values are retrieved, in time stamp order. The zero Quality Column entry indicates that quality details are not retrieved for the values. The Data Source is as per the previous example.)