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 16:51:02
 
 
À
10/08/2001 16:10:56
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:
00542535
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform