Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter problem
Message
From
28/03/2010 13:19:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Alter problem
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 5.x
Miscellaneous
Thread ID:
01457693
Message ID:
01457693
Views:
106
Hi All:

I have a program that works fine on my end, but my client has a problem. He's running Windows XP with Novell.

Here's the code:
tcFileName = 'PO'
WAIT WINDOW NOWAIT 'Now processing ' + UPPER(tcFileName)
USE (tcFileName)  EXCLUSIVE

TRY
	ALTER TABLE &tcFileName ADD COLUMN chk c(1)
CATCH
ENDTRY
On my machine, the above code adds a new field 'chk' the first time the program is run and all subsequent times, it raises an error which is CATCHed, since the field already exists.

On my client's machine, it never adds the field, since it always gets an error. The nessage states 'unable to create temporary work files'. This error happens even when I strip the file down to 5 records. i.e. it is not a size problem.

Can you help?

Thanks,

Yossi
Next
Reply
Map
View

Click here to load this message in the networking platform