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