>Hi all,
>
>Usually when I update my app to the customer site, I will put the newest tables structures to a temp directory and run my update program which will append all records from current directory to the temp. After doing this, I will copy from the temp and back to the exisiting current directory. When copying in progress, it takes time and to user it's like the system 'hang'. Is there any command to rename the directory instead? Or is there anyway I can display a thermometer if I use the COPY FILE command?
>
>Regards,
>Farouk Yew Abdullah

I know this is not what your update program is designed to do, but I will place new table structures in the same directory as the current tables but under a slightly different name. I then do an append from, delete the original table files, and rename the new ones. This cuts the update time in half. But now with VFP3/5 Alter Table command (and Stonefield's utilities), I no longer have to worry about this. You also can not do either of these methods very easily without disrupting anything you have defined in your DBC for such tables.