Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clever way to close all cursors
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00124575
Message ID:
00124586
Views:
24
>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.net
Start making your plans now to attend Southwest Fox 2006
Previous
Reply
Map
View

Click here to load this message in the networking platform