Re: cursors not being deleted by Cindy
Cindy
Thu Jan 13 08:00:56 CST 2005
Hi Sherry (and Paul)
When Paul refers to "temporary tables" he means things that are created in
your app with Create Table who's purpose is for temporary use in your app
and would not be used after the app is finished. Files created with Create
Table have to be specifically deleted with Delete File or Erase File. Files
of this nature would have friendly names like MyTable.dbf and will be
created in the default directory for the app.
If you're creating cursors with Create Cursor or using SQL with Into Cursor
MyCursor then these should be automatically deleted when the app exits.
However, they will be left behind if the app crashes. Files of this nature
would have unfriendly names created by a random name generator and will be
located in the Temp directory.
Can you be more specific about what's being created, where it's being
created, and what command you use in your app to create the files?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
"Paul Pedersen" <no-reply@swen.com> wrote in message
news:Oca8LgN%23EHA.4028@TK2MSFTNGP15.phx.gbl...
> If you're talking about temporary tables that your app created, you have
> to delete them yourself.
>
> If you're talking about temp files in the temp directory, just ignore
> them. The operating system will delete them when it needs the space.
>
>
>
> "sherry" <sherry@discussions.microsoft.com> wrote in message
> news:7ABE559B-05DC-4A68-81C1-B1D3740465AF@microsoft.com...
>> Using vfp8 on windows 2000 and xp.
>> Alot but not all cursors are not being automatically deleted.I thought
>> when
>> the application closed the cursors would automatically be deleted.
>> If I'm wrong, what should I do to correct the problem. They are not
>> causing
>> errors (I don't think) but they are taking a lot of space.
>> Thanks
>> sherry
>
>