Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALTER TABLE error: file c:\temp\0502743.tmp does not exi
Message
From
10/08/2001 16:51:02
 
 
To
10/08/2001 16:10:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00542442
Message ID:
00542535
Views:
25
>c:\temp could be marked as a System folder.
>
>I have this problem temporarily, where the Windows temp folder I assigned is not a System folder for a while, then suddenly one day it is. I have no idea why it suddenly is.

In my case, terminal server was installed. Maybe this causes this problem ?

How to make temporary file folder back to non-system folder on NT server ?

>VFP ignores system folders. Cursors are created in memory but have a path assigned, but not necessarily disk presence.
>When a DBF() (usu. w/ APPEND FROM DBF()...) or ALTER TABLE is fired on it, it tries to get it from disk. Since it ignores system folders, the file doesn't exist.

I checked that

SELECT ... INTO TABLE c:\TEMP\mytbl

works OK. Why in this case error does not occur ?

>You can include a config.fpw file in your exe with a TMPFILES directive to a folder that is definitely not a system file - like a relative path to "myapplicationstempfolder".

Unfortunately, I cannot re-compile exe file. I don't have exact source code. config.fpw file is included in .exe . I can add some init code to this
.exe file using CodeBlock. However, VFP is unable to change TMPFILES setting in code.
How to resolve this ?

Also, I have generic appication and idea not using OS temporary folder for temporary files seems strange.
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform