>Hello. I've been using the alter table statement to add a column to a table in visual foxpro 6.0. The new column is being added to the end of the table. Instead of changing the order the fields appear in the table through table designer, is it possible to change the field order programmatically? Any help would be greatly appreciated. Thanks
The only way to do this programmatically is :
1. store off existing data
2. recreate the table with the desired order
3. restore the data
Just curious, why do you need the field order changed?
Insanity: Doing the same thing over and over and expecting different results.