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