Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-0501:46 PM. Last Modified: 2023-05-0312:34 AM
[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.