>Hi, Everybody!
>
>I want to modify the table structure in a database for my customer, my
>customer has input many data already, and they have not VFP development
>environment! I know I can modify the structure manually in my office, but
>they have to stop their working for one day, so I want to write a program
>to do the modification, which way is better ? I tried the ALTER command,
>but I cannot insert field in the proper order ! Any help is appreciate !!!
>
>Catherina of AS SOTA Co.

Create new database in your office, write program moving data from old structure to new (hopefully it will not be time-consuming), bring both to client office, run the program and delete old database.