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

The alter table should work for you. The position of the field in the dbf strucutre should be of no consequence, if it is important then you have some design problems that will eventually cause you serious problems. In a sound relational design the only thing that matter is the name of the field not its position within the table.