Hi

i'm converting my application from dbisam to EDB2 in this days.


Time 14:40

Open EDbmanager for add the my first field with edbmanager....

looking table.. found it...alter table.. columns page...

hmmm here much problems.

this table have 200 fields , i need add this field in 132' position

ARGGG !

the index of field ( there was in dbisam manager ) there is not more

i can't looking for field index *.*

ok , press : ADD COLUMNS , my new field is in the last position , 100 fields
under..

try drag.drop with mouse , for move up the field but.. NOTTHING , don't
work.

okok , press ALT U , for move up , but when cursor move in up , the grid
don't scroll

and i can't see my row of field , so , my field is in 1' position ( 1' row )


i need move it in 132' position , so press ALT D ( for down )  , and call me
DELETE FIELD ?

Down and delete have always : ALT D key....



i need modify 10 tables.........................

Hi Tim ^^

add...


the Tables list of the single database is not Sorted.

when i add a table , the Table is showed in last position.

Mauro,

<< the Tables list of the single database is not Sorted.

when i add a table , the Table is showed in last position. >>

Sorting in the explorer will be present in the upcoming 2.02 release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mauro,

<< okok , press ALT U , for move up , but when cursor move in up , the grid
don't scroll

and i can't see my row of field , so , my field is in 1' position ( 1'
row )

i need move it in 132' position , so press ALT D ( for down )  , and call me
DELETE FIELD ?

Down and delete have always : ALT D key.... >>

I'll see if I can get this improved for 2.02.  In the meantime, you always
have the ability to simply open an SQL window and enter in:

ALTER TABLE MyTable
ALTER COLUMN MyColumn MOVE TO 132

--
Tim Young
Elevate Software
www.elevatesoft.com

Mauro

>the Tables list of the single database is not Sorted.
>
>when i add a table , the Table is showed in last position.

This is a known issue. The workround is to hack the associated .ini file (carefully)

Roy Lambert [Team Elevate]

Mauro


1. You'll need to use the move up/move down buttons
2. You may want to try adding the new columns in by code. If you look in explorer-sql history you'll see the ddl commands that have been used eg

ALTER TABLE "Billing"
ADD COLUMN "_Sequencex" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
ALTER COLUMN "_Sequencex" MOVE TO 38,
ALTER COLUMN "_Sequencex" MOVE TO 37,
ALTER COLUMN "_Sequencex" MOVE TO 36

You don't need all of the MOVEs just the final one to put it where you want it so something like

ALTER TABLE "Billing"
ADD COLUMN "_Sequencex" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
ALTER COLUMN "_Sequencex" MOVE TO 36

will do the job.

Roy Lambert [Team Elevate]

Roy,

<< This is a known issue. The workround is to hack the associated .ini file
(carefully) >>

How does that help ?  The object sorting code wasn't added until two days
ago, and I'm pretty sure that I didn't give it to anyone yet.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< This is a known issue. The workround is to hack the associated .ini file
>(carefully) >>
>
>How does that help ? The object sorting code wasn't added until two days
>ago, and I'm pretty sure that I didn't give it to anyone yet.

It helps because if you remove things from the .ini then the next time you open it EDBManager gets it right <vbg>

Roy Lambert [Team Elevate]

Roy,

<< It helps because if you remove things from the .ini then the next time
you open it EDBManager gets it right <vbg> >>

I'm still not quite sure what you're talking about ???

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< It helps because if you remove things from the .ini then the next time
>you open it EDBManager gets it right <vbg> >>
>
>I'm still not quite sure what you're talking about ???

Its me I think my brain is currently cross wired - I was thinking of fields (columns) not tables sorry to all

Roy Lambert [Team Elevate]