My client uses the vValue to store the user-selected reason description for the alarm. Would I be able to update the vValue in Historian with a new reason string?
My client uses the vValue to store the user-selected reason description for the alarm. Would I be able to update the vValue in Historian with a new reason string?
I assume you're asking about using a string tag (as opposed to alarm records): Yes, string tags support both INSERT and UPDATE operations the same way as other types of tags. Note the semantics are somewhat different than conventional SQL operations so be sure to follow the examples in the documentation.
If you were, instead, asking about alarm/event history, no INSERTs or UPDATEs are supported--that only supports SELECT.
Hi Elliott. Thank you so much for the response. I am trying to update the historical Equipment09_DowthermTemp.MV.HiHi.AckMsg and get the following message from the OLE DB provider. '"The user did not have permission to write to the column 'vValue''
To perform SQL UNSERTs/UPDATEs on the extension tables requires the login to be an "aaAdministrator".
Also, not sure if this changed from older releases, but using Historian 2023 R2, the "INSERT History (DateTime, vValue..." doesn't work for me, but you can replace this with "INSERT StringHistory (DateTime, Value..."