- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-06-13 04:43 PM
Automation Interface - Simple SQL Query
Hi all,
I have been using a reference to the automation interface from Excel to connect to a GeoSCADA 2020 database and manipulate various objects. I have been able to delete and rename objects and change the properties of various objects as well. All good!
However, I would like to be able to execute an SQL query from the same environment (Microsoft Excel and VBA) and iterate through the results to perform various actions. Is this possible (preferably not via ODBC) and can you provide me with a simple example please?
I know that you can get all objects of the same class {eg: Dim Objs As ScxV6DbClient.ScxV6Objects Set Objs = svr.Objects("CPointAlgManual"} but that doesn’t let you create a result set from an SQL statement.
Any help appreciated.
- Tags:
- english
Authentication Failed.
- Authentication Ticket Mismatched, failed authentication.
Link copied. Please paste this link to share this article on your social media post.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-06-14 04:23 PM
OK, so I ended up using ADO (and ODBC) to execute SQL queries and everything is working well.
- Tags:
- english
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-06-14 04:23 PM
OK, so I ended up using ADO (and ODBC) to execute SQL queries and everything is working well.
- Tags:
- english
Link copied. Please paste this link to share this article on your social media post.

