Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84249members
353348posts

[Imported] Delete from, in script

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

sbeadle
Janeway Janeway
Janeway
0 Likes
0
279

[Imported] Delete from, in script

>>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.