Using Query Recordsets in Scripts

<< Click to Display Table of Contents >>

 

Using Query Recordsets in Scripts

Another interesting usage of a Query is when working with Recordsets. After executing a Query, users can capture the corresponding Recordset and then work with records row by row or execute new Queries. In the next example script, the RS variable assumes all features of a Recordset.

RS = InitialScreen.E3Browser1.Query1.GetADORecordset()

 

The advantage of using this feature is that, when changing properties of a database, there is no need to adjust every script that accesses that database.

Was this page useful?