AnsweredAssumed Answered

RDBMSPI Annotation

Question asked by PJANIN on Aug 17, 2016
Latest reply on Aug 18, 2016 by Steve Boyko

Hello,

We use RDBMSPI Interface to update more than 200 tags from an Microsoft Access database using distribution strategy.

It works well, values are updated correctly, but we want to add sometimes values in the annotation and it doesn't work.

 

Here is the query used :

SELECT QC_TimeStamp, Tag, Result, 0 AS Status, Annotation AS PI_ANNOTATION

FROM QC_All_Data

WHERE QC_TimeStamp > Now() - (5.);

 

QC_All_Data is the table in the ACCESS database.

Outcomes