>Hi ,
>
>I have a program that does some merging of foxpro data.. . ... the tables are the same, but my program does some structure checking. Changes were made to one of the table, but the end result was that the table was still the same. But when the data gets selecte out of the table that I made changes to... the fields are ordered in the order that I changed and re-added them. Of course, then when my structure check takes place, it appears that the tables aren't the same.
>
>Is there a way to order the fields in your table? I didn't really do alot of research on this. This is my first point of research. I need help asap. Thanks.

Other than use modify structure and manually re-order thm I doubt. Of course, you can do:

select field1, field3, field5, field2, etc. from yourtable into table NewTableName

, if the original table is not the part of the database and doesn't have long field names.

I thought about writing a User Interface instead of Modify Structure interface (quite inconvenient, IMHO), but since it was not that necessary, I hold on this idea.