Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALTER TABLE error: file c:\temp\0502743.tmp does not exi
Message
De
10/08/2001 17:56:11
Jonathan Cochran
Alion Science and Technology
Maryland, États-Unis
 
 
À
10/08/2001 16:51:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00542442
Message ID:
00542557
Vues:
16
Whenever I see this, I just go to DOS and type "ATTRIB C:\TEMP -S".

Other cases where I have seen this problem is if the TEMP or TMP environment variables aren't defined.

>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform