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 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))
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
