|
|
Rank: Member
Groups: Member
Joined: 3/24/2009
Posts: 20
Location: Saudi Arabia
|
Hi PI People,
I need to update the SVALUE, FLAG or STATUS fields of a particular pitag. I know how to do this in PIOLEDB but im trying to convert my procedure to PISDK.
I cant figure out how...any help is greatly appreciated.
rgds,
jayson.
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hi Jayson, Can you post your OLEDB snippet (or an example) so I can home in on a PISDK example for you... Cheers, Rhys. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
Rank: Member
Groups: Member
Joined: 3/24/2009
Posts: 20
Location: Saudi Arabia
|
Hi Rhys,
I made a mistake in my question, in my OLEDB command, i can only make insert statement on the PICOMP table, im trying to figure out how to update the svalue or flag fields. If I try to make an update statement on the same table it would return "Table doesn't allow to update rows". Is there a way to update these fields using PISDK. (sorry for the confusion...)
Jayson.
|
|
|
Rank: Administration
Groups: Administration
Joined: 6/20/2008
Posts: 617
Location: Cheshire, United Kingdom.
|
Hi Jayson, In that case then you can use OLEDB UPDATE commands against the picomp2 table, which is fully updateable. picomp only supports insert. Rhys. EDIT: Just for completeness Flags are ValueAttributes in PISDK (Questionable, Annotated or Substituted) and SValue is a string value. Principal Consultant
Real-Time Data Management @ Wipro Technologies
|
|
|
|
Guest
|
