>For anyone who has not already left for the beach this weekend...
>
>Using Alter Table on a standard VFP table I thought you could add a column After or Before another column but the help file shows no such thing. Did I dream I did this before or am I missing something?
>
>If you can't then I will just make a new structure and append the current table. (This is for an update program that will hit a lot of locatons so it has to be fully automated and we always put all the relation keys at the start of the record.)
>
>TIA

>For anyone who has not already left for the beach this weekend...
>
>Using Alter Table on a standard VFP table I thought you could add a column After or Before another column but the help file shows no such thing. Did I dream I did this before or am I missing something?
>
>If you can't then I will just make a new structure and append the current table. (This is for an update program that will hit a lot of locatons so it has to be fully automated and we always put all the relation keys at the start of the record.)
>
>TIA

Im not using VFP 9 but VFP 8 and before you couldn't specify where the column went. It always went to the end of the field. We have our own update procedure because we always put general fields at the end of our tables.