>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?
Evan
I wrote a method to do something similar to what you need some time ago. I named all my cursors step1, step2, step3, etc. To close only the cursors first adir(la_filelist,'step*') gives you a list of all cursors in array la_filelist. Then just step through the array and close each file.
HTH... Bob
Bob Kocher
www.swfox.netStart making your plans now to attend Southwest Fox 2006