Hi Rock,
I've seen this question few months ago. The answer is 'NO', unfortunately. Unless you create a temproraly array of all your fields and recreate a whole table...
>Hi All;
>
>Do you know if we can specify the possition of a column added with the alter table command instead of the last possition.
>
>Ex:
>
>CHANGE
>
>Alter Table "MyTable" add column Myfield C(5)
>
>WITH THIS
>
>Alter Table "MyTable" add column(1) Myfield C(5)
>
>Thank's in advance ...
>Rock
If it's not broken, fix it until it is.
My Blog