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