Hi, I'm new with PI Oledb and I need some help
I'm trying to force the follow error: "Row insertion failed [PI SDK] Passed timestamp is in the future" that I'm getting with PIOLEDBTester, with my program developed in c#but when I run it it seems that it does insert, but when check it doesn't.
how can I capture or get the error?
the insert int PIOLEDBTester is:
INSERT piarchive..picomp2 (tag, time, value)
Select 'CA-068_WHP','16/01/2012 12:27:04:00 a.m.', 0
UNION
Select 'CA-068_WHP','16/01/2012 12:27:09:00 a.m.', 1
UNION
Select 'CA-068_WHP','16/01/2012 12:27:14:00 a.m.', 2
UNION
Select 'CA-068_WHP','16/01/2012 12:27:19:00 a.m.', 3
UNION
Select 'CA-068_WHP','16/01/2012 12:27:24:00 a.m.', 4
UNION
Select 'CA-068_WHP','16/01/2012 12:27:29:00 a.m.', 5
UNION
Select 'CA-068_WHP','16/01/2012 12:27:34:00 a.m.', 6
UNION
Select 'CA-068_WHP','16/01/2012 12:27:39:00 a.m.', 7
UNION
Select 'CA-068_WHP','16/01/2012 12:27:44:00 a.m.', 8
UNION
Select 'CA-068_WHP','16/01/2012 12:27:49:00 a.m.', 9
and is the same in c#
thanks a lot for your help, and sorry for my english, is not my natural language