Can I get some help in defining a SQL Driver template for pulling values from another VTScada system?
ODBC driver is installed, user account with remote data permissions created, realm created, DSN defined, connection verified.
There is no option in the database type list for VTScada. What should be chosen here?
I made a probably incorrect assumption that a query should follow the format described in the SQL query documentation here
SELECT '^A' , Timestamp FROM History ORDER BY Timestamp DESC LIMIT 1
Where address of the I/O tag attached to the SQL Query Driver is
RemoteContext\Sub Context\Interesting Part:Value
This, of course, is not working. I just want the latest value for tags. Some help with this "Instantly Intuitive"™ task would be appreciated.