Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temp directories and ALTER TABLE command
Message
 
 
To
20/11/2001 11:05:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00583915
Message ID:
00583963
Views:
22
>You can use editwork,sortwork,progwork w/o a drive identifier. Now you can do that for tmpfiles too but formerly was only setting drive.
>
>editwork = temp && Temp directory under app path
>sortwork = \tempfiles
>
>Cetin

Hi Cetin,

How can I include config.fpw file into project (under wich tab)?

I've defined this config.fpw and added it under text files item, but it didn't change sys(2023) (it shows d:\temp still).

Here it is, what did I do wrongly?:
********************************************************************
*  Description.......: config.fpw
*  Calling Samples...: 
*  Parameter List....: 
*  Created by........: Nadya Nosonovsky 02/11/2000 10:57:54 AM
*  Modified by.......: Nadya Nosonovsky 02/11/2000 11:01:50 AM
********************************************************************
*screen=off
talk=off
*safety=off
*exact=off
notify=off
keycomp=windows
echo=off
status=off
talk=window
*command=do D:\Utilities\vfpstart.prg
resource=off
tmpfiles=\redp\work\temp
>
>>>>Hi everybody,
>>>>
>>>>I need to understand, where Fox tries to create temp files during INDEX ON and ALTER TABLE commands on huge tables. I was thinking, it uses current place for temp files, but it seems, like it uses current location of databases instead.
>>>>
>>>>I'd like to check for available space before running ALTER TABLE / INDEX ON command, and I need to know, how many space I need and where.
>>>>
>>>>My second question is: can we re-direct temp files to the specific location for the specific application (this application is run under another main application). If yes, how?
>>>>
>>>>Thanks a lot in advance.
>>>
>>>It uses temp dir.
>>
>>Hi Cetin,
>>
>>I'm not sure. Let me explain, that happened. In my code I check Available space on current temp drive
pcTempDrive=justdrive(sys(2023)) && VFP Temp drive
When I ran my DataDict program, it gave a message, saying not enough free space to create g:\redp\dbc\ma\tranmstr.tmp (something like that), so I'm guessing, it also needs space on the drive, where tables located...
>>
>>My second question is: can I put path in config.fwp without drive letter, e.g.
>>\redp\Work\Temp?
>>
>>Thanks in advance.
>>
>>>For redirection use config.fpw :
>>>tmpfiles = path
>>>
>>>Also there are :
>>>sortwork = path
>>>editwork = path
>>>progwork = path
>>>
>>>options if you want to set them separately.
>>>Cetin
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform