AnsweredAssumed Answered

why does PI SQL Commander/PIOleDB tool return a value that is different than the PISDK

Question asked by IOMHouston on May 27, 2011
Latest reply on Jun 9, 2011 by IOMHouston

Using the PI ole tool with the following query

 

SELECT tag, time, value, DIGSTRING(status) status FROM piarchive..picomp2 WHERE tag = 'SINUSOID' and  
                 time > '27 May 2010 04:31:09.006' and time < '27 May 2011 04:31:09.021'

 

 

 

 

 

the following is returned.

 

      tag                     time                                      value             status

 

      SINUSOID     5/27/2010 4:31:15 AM     98.43456         Good

 

      SINUSOID     5/27/2010 5:31:15 AM     98.15228         Good

 

      SINUSOID     5/27/2010 6:40:45 AM     81.88809         Good

 

      SINUSOID     5/27/2010 9:33:15 AM     13.6564           Good

 

      SINUSOID     5/27/2010 10:36:45 AM     1.025669       Good

 

 

 

Using the SDK

 

 

 

PISDK.PIValues piValue3 = piPoint.Data.RecordedValues(

 

                "27 May 2010 04:31:09.006",   "27 May 2011 04:31:09.021",
               PISDK.BoundaryTypeConstants.btOutside);

 

 

 

98.15228        Server:5/27/2010 5:31:15 AM

 

81.88809        Server:5/27/2010 6:40:45 AM

 

13.6564          Server:5/27/2010 9:33:15 AM

 

1.025669        Server:5/27/2010 10:36:45 AM

 

 

 

Why is the first record, 4:31 AM that is returned in the PI OLE not appear in the SDK query.

 

NOTE: Only the first few values are shown.

 

I thought the OLE DB uses PISDK, so something else must be used? Is there a setting to 
ensure that these two tools have the same behavior?

 

 

 

 

Outcomes