Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter problem
Message
From
14/06/2010 12:21:25
 
 
To
14/06/2010 12:14:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 5.x
Miscellaneous
Thread ID:
01457693
Message ID:
01468827
Views:
57
The switch is exactly the same as for vfp.exe, namely -c.

>Naomi:
>
>Yes, but I can't seem to find the proper way to specify WHICH config.fpw to use when I execute my EXE file. (I could only find the switches used when invoking VFP.EXE).
>
>Yossi
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform