4 Replies Latest reply on Jan 14, 2018 9:43 PM by John Messinger

    PIOLEDB question about SQL-commands

    HansvandenBovenkamp

      Hi All,

       

      Im starter in PI OLEDB to use SQL-Commands,

      I have a question,

       

      When I use the next command, I get data rows back, as expected

       

      SELECT * FROM PIARCHIVE..PICOMP2 WHERE TAG = 'TAGXXXXX' AND

      TIME BETWEEN '2017-12-20' AND '2017-12-21'

       

      When I use the next command, replace SELECT * by SELECT COUNT(*),

      I got error message,  I dont understand, who can help me,

      Thanks in advance

       

      SELECT COUNT(*) PIARCHIVE..PICOMP2 WHERE TAG = 'TAGXXXXX' AND

      TIME BETWEEN '2017-12-20' AND '2017-12-21'

       

       

      2018_01_11_21_32_21_Examples.docx_Word.png