You were getting the error because there is no such Destroy() method for
the SQLListTables class.
The only two classes that have the Destroy() method are: SQLStatement
and SqlParameter classes. Unrelated, but just in case you use
SQLParameter, according to the SDK, "If you instantiate a SQLParameter
object, you should explicitly destroy it when you are finished using it".
And remember the Close() method only closes the cursor, not the connection.
Jamal
As you found, the Close() method should work fine.
On 7/15/2021 3:44 PM, Henry Fidler wrote:
Wolfgang many thanks
I did what you have suggested,
I do not know what the method Destroy() should do, so I have just
Self:Close()
Until now it works OK.
Thanks
Henry
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)