>>Message imported from previous forum - Category:Scripts and Tips<< User: mchartrand, originally posted: 2018-10-25 17:57:00 Id:261 This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.
**_Andrew: Can i run a query and use the delete statement_**
trentonite: Yeah you can but only against table items.
ex: I have a data table named TestDT and want to clear its contents
DELETE FROM TESTDT
additionally, you can use update queries to update properties on objects
ex: I want to update a points alarm source where it's ID = 12345
UPDATE CPointAlg SET AlarmSource = 'Test Pt Alarm Source' WHERE ID = 12345
I don't believe you can do a DELETE from against property/metadata values so you'd end up running an update and setting the value to empty ( '' )
AWoodland: Just to expand on the above comment, look up Server.Query in the help for how to actually execute the queries.