Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter problem
Message
 
 
À
16/06/2010 10:54:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 5.x
Divers
Thread ID:
01457693
Message ID:
01469242
Vues:
65
The ALTER TABLE command create a temporary file (table) in the same directory as original table. Maybe it's permission issue on Novell?

>The Anti Virus is turned off.
>
>Note that the program and param.dbf are in F:\data, which is a mapped network drive by Novell. The problem does not occur when I'm using a local drive. Here is the code that is causing the problem:
>
>
>CLEAR
>CLOSE ALL
>SET SAFETY OFF
>SET CENTURY ON
>
>* In my Config.fpw, I have the following line:
>* TMPFILES=c:\junk
>* The following line confirms that C:\junk is the temp folder, so no long names here
>MESSAGEBOX(SYS(2023))
>
>USE param
>
>TRY
>* if PARAM.scexp doesn't exist, then we do the CATCH
>	X = PARAM.scexp 
>CATCH
>
>* THE FOLLOWING LINE BOMBS WITH A 1410 ERROR
>* "UNABLE TO CREATE TEMPORARY WORK FILES"
>**** WHY? ********
>	ALTER TABLE PARAM ADD COLUMN scexp c(3)  
>	REPLACE scexp WITH '90'
>ENDTRY
>
>
>Can anyone help on this?
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform