I am using PI SQL Commander to to directly insert values into PICOMP2 table of PiArchive.
following statement is used to insert DIGITAL STATE VALUE in it.
INSERT INTO [piarchive].[picomp] (tag,time,value) VALUES('MyTag','*',"'DATABAD'")
Before working with this statement I create the 'DATABAD' state in PI SMT->Points->Digital States->SYSTEM
I assigned the DATABAD as StateName for State 99
After executing that statement the following error is generated by PI SQL Commander.
"Values must be convertible to data types of corresponding columns."
Then How can I assign such digital state values incase of no valid data available.
Thank in advance