We're trying to insert a digital state value through a SQL query (through a SQL linked server) but we're receiving this error message:
[OLE/DB provider returned message: Row insertion failed.
Digital state code couldn't be converted to a digital state.]
We're trying to insert a plain integer value that is supposed to be converted. Assigning a value through archive editor works well but through the SQL statement we've got the error mentionned above.
Any help would be appreciated.
Here's an example of the SQL query:
INSERT PI.piarchive..picomp2 (tag, time, value)
VALUES ('260-345-SIL-001.WI.MAN', '11/3/2009 9:00:00 PM', 50)