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

    shekar

      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.

       

      thanks,

      Madhu