At 03:49 PM 12/02/2004 +0000, you wrote:

>is it any simple way (as RDB$FIELD_POSITION) to change record position
>in column? or I must add additional attribute to specify position
>records position in the table (problems when changing order as
>neighbours take action too)
>I have record list in listbox and need to change their order in the
>table - move up or down (1 2 3 4 => 1 2 4 3 => 1 4 2 3)
>Or there is more ways?

ALTER TABLE MYTABLE
ALTER COLUMN MY COLUMN POSITION n

n is the 1-based left-to-right position where you want the column to
be. The other column positions are adjusted automatically.
/hb