>Hello Nadya,
>
>Instead of ALTERing the original table, you could do the process manually. Copy one record to another (temporary) table, in the temporary location. Alter that table, then do an append from the original. Then copy the new file over the original.
>
>HTH,
>
>-steve

That's an interesting idea, though all code is already written and tested. Tables are part of DBC. So, can you elaborate more on your suggestion? (Seems like a tremendeous change in the existing algorithm :()
>
>>Hi everybody,
>>
>>Seems like my first question led to a dead end :(
>>
>>Also I'm not convinced, that ALTER TABLE command creates temp files in TMPFILES directory (specified in config.fpw). The error message, I got, indicated, that it was trying to create temp file on the network drive.
>>
>>INDEX ON command seems to put their internals under SORTWORK path according to Help file.
>>
>>I have a problem. I need to run ALTER TABLE and INDEX ON commands on huge VFP tables (about 5mln. recs). I want to check for free space prior to running these commands.
>>