>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).
Mark McCasland
Midlothian, TX USA