>>Nick,
>>
>>I have few other questions:
>>
>>1) How can I stop executing ALTER TABLE command for a huge table? The same for Index ON command?
>
>You can stop both by pressing ESC key, however I don't think it will do you any good.
>
It should just cancel the process without altering/indexing, right?
>>
>>2) How can I show a Progress bar for these commands?
>
>Nothing as far as I know for these commands can show a custom progress bar however there is a system progress bar showinfg for ALTER TABLE command "Records Added" and a percentage.
When you do Modify Structure command for the huge table, you'll see a progress bar. Is it possible to have something like that?
I'll try SET TALK ON...
>>
>>3) Is there any function to return file size (perhaps, API) besides ADIR() or WSH? I don't want to mess with set compatible for fsize().
>
>Why you don't want to use these ones? They work. :)
Well, I wanted one-liner, but I don't want to mess with set compatible...
Anyway, I'll probably will go with adir().
Thanks again.
If it's not broken, fix it until it is.
My Blog