I'd like to retrieve string values from PI through a sql query using PI ODBC driver
My query is:
SELECT svalue FROM picomp WHERE Tag="mytag" and time = date('*')
As soon as i execute it, my application (SQL-View) crashes.
I'm able to retrieve all other elements from picomp table such as Tag, time, value,etc...
But if i ask for svalue.... Crash...
Hope you can help me