Hi Bradley.
>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?
The only way you can do this is to create a new table with the desired structure, APPEND FROM the old table, then delete the old table and rename the new one.
If you're interested, Stonefield Database Toolkit can do this for you without you having to write any code or worry about all the steps necessary. For more information, see
www.stonefield.com.
Doug