I've changed column order:

ALTER TABLE table
ALTER COLUMN column_1 MOVE TO        01,
ALTER COLUMN column_2 MOVE TO      02,
ALTER COLUMN column_3 MOVE TO    03;

Script was exectuted ok.

But columns in grid are showing in old order. Reestart EDBMgr and old
order is showed again. The same with not saving explorer state (in
preferences).

But, if you alter table in EDBMgr, you'll se the correct order.

Drop a TEDBTable in a form, and add fileds, you'll see incorrect
order.

Open a TEDBTable in a grid (without instantiating fields), you'll see
old order.

ALTERed and MOVEd order only can be seen in EDBMgr alter form.



Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago


Every so often I go and clean up the .ini file - that helps.

Roy Lambert

Tiago,

<< But columns in grid are showing in old order. Reestart EDBMgr and old
order is showed again. The same with not saving explorer state (in
preferences). >>

I just tried this:

ALTER TABLE biolife
ALTER COLUMN Notes MOVE TO 1 -- Notes was the last column originally

and then hit F5 to refresh the treeview, and the Notes column moved to the
first column position as expected.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<I just tried this:

ALTER TABLE biolife
ALTER COLUMN Notes MOVE TO 1 -- Notes was the last column originally

and then hit F5 to refresh the treeview, and the Notes column moved to the
first column position as expected. >

I think I found it. Please see your support mail account.