Hi Martina:
I'm no longer using the macro and still getting the error.
I want to try and specify a temp folder with a short name. Forgive me, but I've forgotten how to do this with my EXE. Can you help me?
Thanks,
Yossi
>Hi Yossi,
>
>No, makro(&) has problem with long names.
>
>MartinaJ
>
>>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