Hi

I'm trying convert my DbIsam application to EDB2

list of my problem , found in my work....


Max File Name in EDB2 is too short
Max Field Name in EDB2 is too short

db of my clients must be changed manually with delphi code  



Migrator convertor ( edbmanager ) stop the import function all times found a
Field too long.
For relaunch the Migrator database util i must press DROP TABLE on all table
, one at a time !!!

no hot key
no multiple selection !!!

i have 400 tables... is not usable in this mode.
( i can't use EDB Manger for convert db , will try with my delphi code
manually ... )



other 2 dbManger notes :

i can't view all Fields together ( there is not a grid ) of the one table.
To see only one field for time is TERRIBILE !!!

*.*

The problem there is in the indexs Structure, too.


ok , for today is all

tomorrow,  day two.

Enrico


The maximum length for names is 40 characters, and, apparently, even if you have the source code its not a good thing to change.

There's a faster way to get rid of all the tables - drop and recreate the database - that should do it (its not something I've tested) and you should be able to write a little script to do that, save it to file and re-run as necessary. You'll need to be at the session/database level rather than the table level to do this I think.

<<i can't view all Fields together ( there is not a grid ) of the one table.
To see only one field for time is TERRIBILE !!!

*.*

The problem there is in the indexs Structure, too.>>

This point has been made to Tim and I think its on his to do list.

Roy Lambert [Team Elevate]

Enrico,
<<  no hot key >>

The Delete key will drop any table in the EDB Manager.

<< no multiple selection !!! >>

That's coming in 2.02.

<< i have 400 tables... is not usable in this mode. ( i can't use EDB Manger
for convert db , will try with my delphi code manually ... ) >>

As Roy indicated - just drop the database and re-add it.  That will remove
all of the tables in one shot.

<< i can't view all Fields together ( there is not a grid ) of the one
table. To see only one field for time is TERRIBILE !!! >>

Are you talking about when altering a table, or when just viewing the
structure in the EDB Manager explorer ?  Both offer list views that show the
table columns in a "grid" type of view.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

>>Are you talking about when altering a table, or when just viewing the
>>structure in the EDB Manager explorer ?  Both offer list views that show the
>>table columns in a "grid" type of view.

When altering a table you get a nice grid view in the columns tab - but when selecting
database->table->Columns in the treeview, you get only icons with the tablename, and when
selecting one of them the information about just one column.

It may look nicer and more windows-explorer-like, but in my opinion a simple "select *
from information.tablecolumns where tablename=xyz"-grid would be way more informative and
well arranged than this type of view. Old fashioned, but you get your information with one
look.

Heiko

>>you get only icons with the tablename

meant the _column_ name...

Heiko,

<< When altering a table you get a nice grid view in the columns tab - but
when selecting database->table->Columns in the treeview, you get only icons
with the tablename, and when selecting one of them the information about
just one column. >>

My apologies - this is something that needs to be made more clear via a
visible button because it keeps tripping people up:

You can right-click on the Properties tab and select the view type.  Setting
it to Details will give you what you want.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Ooops...of course, I right-clicked just about everything in sight - but not the tab...

Thanks for the hint !!

Heiko

Heiko,

<< Ooops...of course, I right-clicked just about everything in sight - but
not the tab... >>

Well, like I said, it isn't very obvious and needs to be put in plain sight.


--
Tim Young
Elevate Software
www.elevatesoft.com

Tim
I know its retrograde but I'd like to return to a display for an individual table more like DBSys. I find it much more convenient to click on a page tab to get the various bits of info about a table rather than use a treeview.

Roy Lambert

Tim


>You can right-click on the Properties tab and select the view type. Setting
>it to Details will give you what you want.

Tried this and it looked good, just went into EDBManager and I find its a setting for the whole of EDBManager. which is not so good. Icons are better for some parts (most in my view) and details better for others (columns, indices). Can you give some thought to setting it dependent on the type of stuff being displayed?

Roy Lambert