>Hello,
>
>Currently we are using the ALTER TABLE command to add new fields to existing tables.
>
>These new fields always append to the bottom of the tables.
>
>What command can we use to move these new fields to somewhere other than the bottom of the tables? Say, if we wanted to move them to the middle?
>
>Thanks!
>Joeeeeeeeee
I don't think there is a command but you could easily create a new structure in code and append from the old table, add the new values, then delete the old table. Another way would be to just alter table and place the new fields at the end like you do now, then select fields into another table in the order you like. BTW, the order of fields in raw data shouldn't matter unless you are relying on default layout for something like a grid, which you shouldn't do, IMHO.
HTH
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California