Hi Martina:
Sorry for delayed response!
1) I'm using (tcFileName)
2) sys(2023) is c:\DOCUMEN~\SSM8\LOCALS~1\TEMP
Could it have something to do with Novell not being able to handle long file names?
Thanks,
Yossi
>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