Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Designer and Associated Cursors
Message
 
 
To
29/07/2007 11:42:05
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01244433
Message ID:
01244449
Views:
18
>VFP leaves alot of cursors open after opening and closing views. Often I find a dozen or more open when I use the SET command to look at my data sessions. These 'left-over' cursors are sometimes problematic when I'm trying to open new views or the same view that I worked on previously so I've written a little function that will close all open cursors. This works great, except ... if I still have a view open, I get the following message: "Cursor '????' cannot be closed because it is used by View/Query designer."
>
>Is there a way to programically know when an open cursor is associated with an view that is still in used by the designer. If there is, I can skip trying to close these particular cursors?

You can use AUSED() to get the list of open tables/cursors and then close them one by one with USE command wrapped in TRY...ENDTRY to ignore the error.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform