When I write the code for a query using adodb I can clear it after use by using something like
Set Newrst = Nothing
I have been working with Sage Line100 which does not seem happy with recordsets and have therefore used ODBC and Querytables instead.
Can any one help me with shutting down such a query. Code such as
Set Sageqt = nothing
Although it does not cause an error, does not work so the number of named corrections grows as the application is used.
What should I using to clear the query after it has been used