>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?
>
>Thanks,
>Robert Wright
See this function by Daniel Rouleau to return table names used in the view:
Re: Listing tables from SQL sentence Thread #
829127 Message #
829131
If it's not broken, fix it until it is.
My Blog