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.