Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter problem
Message
From
16/06/2010 14:37:34
 
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:
01469286
Views:
46
Sergey:

Interesting! I see that when I right-click on the folder and click 'new', the only option I get is 'folder'. Does that indicate a permission problem?

Yossi

>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?
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform