AnsweredAssumed Answered

PIOLEDB question about SQL-commands

Question asked by HansvandenBovenkamp on Jan 11, 2018
Latest reply on Jan 14, 2018 by John Messinger

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

Outcomes