Wish Resultset AutoClose Property

[advansis]

Some times I forgot to close a Resultset after reaching the end. It would be very useful to have an AutoClose property, that closes the object when NextRow returns False.
Hope it will be useful to others. PS. Any way to rewind the cursor ?

 

[Erel]

Any way to rewind the cursor ?

Dim jo As JavaObject = ResultSet1
jo.RunMethod("beforeFirst", Null)

If you are using it with JdbcSQL then the result type might be "forward only" which means that this call will fail.

Some times I forgot to close a Resultset after reaching the end.

SQLite ResultSets and Cursors will be closed automatically when the object is released by the garbage collector.