saxyogi

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.

 

Yogendra

Outcomes