Re: Is This a WTF, or Just Captain Jake Being Dense?

Oh, I didn't realize there were any that didn't. Does that mean you have to
manually close all open datasets on a data module, for instance, or you'll
get exceptions when freeing the DM?

CoreLab has added a handy property to their components named AutoClose which
addresses that point to some extent. When the property is set, it closes the
db cursor after all the records have been fetched. Very useful for lookup
tables and such since Closing the dataset throws away all the query results.


"Eric Grange" <egrangeNO@xxxxxxxxxxxxxxx> wrote in message
news:45127591$1@xxxxxxxxxxxxxxxxxxxxxxxxx
A possible improvement.. there's no need to wrap the DataSet.Open / Close
in a block because DataSet.Free also Closes the dataset.

This isn't a requirement of all datasets, ours f.i. systematically barf if
they haven't been closed by the time your free them.
This is to prevent datasets being "forgotten" in an open state (and thus
squandering DB resources, both client and server side, when they're not
causing trouble with transactions).


.