Tim

I just added a column to a table, moved it up to the position I want but when I open the table the new column is displayed at the end not where I asked it to be.

Roy Lambert

Roy,

<< I just added a column to a table, moved it up to the position I want but
when I open the table the new column is displayed at the end not where I
asked it to be. >>

It's a bug introduced in 1.06 in the EDB Manager.   The column display is
messed up, but the column is actually moved to the new location.  If you
stop the EDB Manager and then restart it, you will see the changes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>It's a bug introduced in 1.06 in the EDB Manager. The column display is
>messed up, but the column is actually moved to the new location. If you
>stop the EDB Manager and then restart it, you will see the changes.

Maybe in 1.07 but in 1.06 the new column stays at the end.

Roy Lambert

Also the same in 1.07. Look at the table definition (via the alter table option) and the new field is where I put it, open the table and its at the end.

Roy Lambert

Roy,

<< Maybe in 1.07 but in 1.06 the new column stays at the end. >>

Did you stop and then restart the EDB Manager after performing the alter ?
It should be in the correct position.  The Alter Table functionality in the
EDB Manager uses the column positioning in the tree view when altering the
table, so it is subject to also showing the wrong position.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>Did you stop and then restart the EDB Manager after performing the alter ?
>It should be in the correct position. The Alter Table functionality in the
>EDB Manager uses the column positioning in the tree view when altering the
>table, so it is subject to also showing the wrong position.

Does deleting 1.06 and install 1.07 count as "stop and then restart the EDB Manager"? <vbg>

Roy,

<< Does deleting 1.06 and install 1.07 count as "stop and then restart the
EDB Manager"? <vbg> >>

Well, I'm not seeing it here.   A stop and restart fixes the column display
after the alter table to add and move the column.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I just tried

ALTER TABLE "Users"
ALTER COLUMN "_fkemAddress" MOVE TO 5,
ALTER COLUMN "_fkemAddress" MOVE TO 6

(using the UI rather than typing code)

Closed EDBManager, restarted it and _fkemAddress is still at the end when I open the table, still in the right position when I select Alter.

Are there persistent layouts somewhere?

Roy Lambert

ps can you recommend a good alternative to Users. I'm going to rename my table cos I keep wanting to click on your Users

Roy,

<< I just tried

ALTER TABLE "Users"
ALTER COLUMN "_fkemAddress" MOVE TO 5,
ALTER COLUMN "_fkemAddress" MOVE TO 6

(using the UI rather than typing code)

Closed EDBManager, restarted it and _fkemAddress is still at the end when I
open the table, still in the right position when I select Alter. >>

I'll have to test that.  I was testing what you originally posted - add a
new column and then move the new column in the same alter table operation.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Are there persistent layouts somewhere? >>

I forgot to get back to you in reference to this issue.  Yes, there are
persistent layouts in the EDB Manager.  To reset the layout for any given
table, just right-click on the headers of the grid when the table is open,
and then click on the Reset Columns popup option.  That will reset the
layout back to the table default.

--
Tim Young
Elevate Software
www.elevatesoft.com