AnsweredAssumed Answered

How to retrieve a string value with a sql query PI ODBC

Question asked by PatrickVEYRE on Sep 29, 2016
Latest reply on Sep 29, 2016 by vkaufmann


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