Keep an empty table with your temp structure. At runtime, copy this struct to a temp table and append from the old table.

Or, better, :) use a SELECT SQL:

select id, english, danish, swedish from oldtable into cursor temptable

But why do you need something like this? I've never needed to change the order of the fields in a table.

Vlad

>I am looking for a way to reorder the fields in a table. I have a table like this:
>
>id N(4,0)
>swedish C(30)
>english C(30)
>danish C(30)
>
>and I want it temporarily to look like this:
>
>id N(4,0)
>english C(30)
>danish C(30)
>swedish C(30)
>
>This can easily be done in the Table Designer but I want to do it by code!
>
>/Pierre Unge, Sweden