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