>>>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.

I prefer a way to discipline coding: enumerating all cursors (CREATE CURSOR ...) in Form.Init event and closing them in Form.Destroy event. To be precize I use convention aliases: i.e. if form name is frmSearch then cursors will get alias 'curFrmsearch1','curFrmsearch2' etc, i.e. it's easy to write some generic method to trace all used cursor aliases in Form.Destroy event.