Annotations and PI OLEDB Queries

Discussion created by saxyogi on Jan 26, 2011
Latest reply on Feb 9, 2011 by spilon

Hi Guys,


I have two questions regarding PI OLEDB as following.


1.    Is there an difference the way I create an annotation on a PIValue using PI System Management Tools’ Archive Editor Vs If I use a PIOLEDB Insert Query? Such as INSERT PIArchive.picomp2(tag, value, time, annotations) VALUES ('{0}', {1},'{2}','{3}').


2.    If answer of first question is No then why “PIOLEDB Select query” is showing an “#ERROR” in annotations column (Query: SELECT time, value, annotations FROM piarchive..picomp2 WHERE tag = 'tag name' AND time >= '*-70d' AND annotated = TRUE). This annotation is created using PI System Management Tools’ Archive Editor.


Thanks in advance.