AnsweredAssumed Answered

How can I get sampled data from a digital tag with PIOLEDB

Question asked by esancha on Nov 10, 2016
Latest reply on Nov 10, 2016 by esancha



I'm trying to get sampled data from PI with PIOLEDB through the next query

SELECT Time, Value FROM piarchive..piinterp2 WHERE tag = 'FFH:B_002' AND time BETWEEN 't' and '*' and the result its a numeric value not related the digital state of the tag (-2293772)

Some messages from this forum talk about using name, but if I use it, an error occurs: "Column name 'name' is invalid."


How can I obtain this data?


Thank you.

Regards, Emilio Sancha