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