Try setting tmpfiles in the config.fpw (see config.fpw topic in Help)

Check TMPFILES



>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