Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Orphan TMP files
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00195946
Message ID:
00195990
Views:
22
>As you know, when you create a cursor with CREATE CURSOR, Foxpro creates a TMP file in the temp directory. And when you close the cursor, Foxpro deletes the TMP file. Great. But if you do ALTER TABLE on that cursor, Foxpro won't delete the TMP file when you close the cursor. I found this out the hard way when a user had over 14,000 file in her TEMP directory!
>
>I didn't see anything about this on Microsoft knowledgebase. Does anyone know why this happens? Is it a bug? It happens in 3.0b and 5.0a

Sorry, didn't notice you checked KBs. Anyway, I just tested vfp5.0a, and the Alter Table TMP does get left behind, unlike 6, which cleans up perfectly. I'm pretty sure I've seen that reported somewhere, though maybe not in MS KB...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform