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
WHERE QC_TimeStamp > Now() - (5.);
QC_All_Data is the table in the ACCESS database.