Automation Interface - Simple SQL Query

[srigby]

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.

[srigby · Accepted solution]

OK, so I ended up using ADO (and ODBC) to execute SQL queries and everything is working well.