Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter problem
Message
 
To
28/03/2010 13:19:32
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:
01457697
Views:
61
Hi Yossi,

1) instead &tcFileName use: (tcFileName)
2) what is value of SYS(2023) on client machine?

MartinaJ

>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
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform