<< Click to Display Table of Contents >>
Using Query Recordsets via Scripts |
Another interesting usage of Queries 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, for example. In the next command line:
RS = InitialScreen.E3Browser1.Query1.GetADORecordset()
The RS variable assumes all features of a Recordset. The advantage of using this feature is that if database properties change, there is no need to adjust every script that uses this database.