error trying to insert a digital state value

Discussion created by ssavignac on Nov 3, 2009
Latest reply on Nov 24, 2009 by spilon



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:


PI.piarchive..picomp2 (tag, time, value)
VALUES ('260-345-SIL-001.WI.MAN', '11/3/2009 9:00:00 PM', 50)