2 Replies Latest reply on Jul 29, 2015 6:58 AM by shekar

    c# code to delete specific row from PI Archive using 'value' column in osi pi


      Hi Team,


      I want to delete the wrongly inserted values like 'Configure, I/O Timeout etc...' from PI Archive through PI OLEDB using c# code.


      For this I tried the below command but it is not working.


      Delete From [piarchive].[picomp2]   

      Where ( value = 'Configure' or value = 'I/O Timeout' ) and tag = 'sinusoid' and time between '*-1h' and '*'


      Can anyone provide me the solution to delete the data based on the value column.