>Hi Nadya on the VFP help file in the index tab type config.fpw once you open you will see all the available options take a look to the SORTWORK and TMPFILES.
>

My problem is, that I need to have it for this application only and only under certain mode. I think, the later is unavailable, but I can set it for the whole application and include config.fpw into the project. This is what I thought.

Thanks.

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