Cursors and tables remain open after a program runs...they aren't scoped like variables.
However, if a form has a private datasession, its tables and cursors that are closed when that form is closed.
>When is a SQL created cursor released?
>
>By that I mean with are the resources in the form of memeory and swap files (for big data sets) released.
>
>I observe that a USE, if the cursor is active, removes it form the data view window, but are the resources released?
>
>I thought it might be when the calling program is closed, but tests do not support this idea.
>
>Thanks,
>
>Dennis Lytle
>Princeton PC Systems
Steve Gibson