AnsweredAssumed Answered

Update via RDBMSPI Tag to SQL-Server

Question asked by UlrichRuediger on Sep 7, 2020
Latest reply on Sep 7, 2020 by UlrichRuediger

Hi

I have a Problem with RDBMSPI.

I change the data of a string TAG in a Analyse of PI-AF.

Now i try to write the value and timestamp of this tag via RDBMSPI by

/SQL="UPDATE CAS_TEILANLAGE SET Bemerkung = ? , Bearbeitungsdatum = ?  WHERE TEILANLAGE_ID = 1534 ;" P1=VL  P2=TS

Sometimes i find changed data in table, sometimes nothing changed in table when tag is changed.

When I restarted Interface, data will be changed in table.

For tag devinition look at screnshots

 

scan Interval  is 1 Minute

 

Thanks for help

Outcomes