Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter problem
Message
 
 
To
16/06/2010 10:54:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 5.x
Miscellaneous
Thread ID:
01457693
Message ID:
01469242
Views:
78
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform