>>In reports (sometimes in forms), I can use over half a dozen temporary cursors to extract and format data. Does anyone have a clever way of closing all cursors used in a report. I have grown tired on manually destroying all cursors at the end of a method or upon the closing of a report.
>>
>>Since I open all my tables at the start of the app (still the old fashioned way), I could count the highest table # and when a report or form is release make a loop to close tables and cursors higher than than number. Is there a more clever way?
>
>If you make the report have a private DE, you don't have to think about it. The *USE* command has an option *NoRequery DSID* where you can put *1* for the DSID and it will use the information in the already opened tables in the default DS (i.e., little or no performance hit).

I don't understand... perhaps we are talking about two different things.

The temporary cursors that I am refering to are created using SQL-select statements. It is these that I want to close, not the actual tables.