With the EDB Manager, how can I rename a table name?  I imported a
couple DBISAM tables I wanted to use, but need to rename them for this
schema.

Lance

Lance


Check out other threads. My understanding is that at this point you can't. I think Tim said he's going to introduce it later but his primary concern was for compliance with the standard and that doesn't allow it.

The logic is that you could screw up RI (IIRC).

Roy Lambert

Lance,

<< With the EDB Manager, how can I rename a table name?  I imported a couple
DBISAM tables I wanted to use, but need to rename them for this schema. >>

The only way to rename tables at the moment is to create the new table, move
the data over with INSERT INTO SELECT, and then drop the old table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> << With the EDB Manager, how can I rename a table name?  I imported a couple
> DBISAM tables I wanted to use, but need to rename them for this schema. >>
>
> The only way to rename tables at the moment is to create the new table, move
> the data over with INSERT INTO SELECT, and then drop the old table.

Isn't easy to implement a "Rename" or something ?

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Thanks Tim and Roy...

Well....   That all makes sense.   That may be something that EMS can do
when they add support for ElevateDB.  I can understand the reason as you
pointed out.  Still would be nice to have visually a rename, then have the
needed logic under hood.

Then again...   I need to remember that you put in a tool to do general
basic things and its up to us or other tool makers to make it do REALLY cool
things.

BTW:  I do really like what you did with the UI and the Manager.

Lance


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:1148E29C-ADD8-4A65-B5DD-D76E94C23159@news.elevatesoft.com...
> Lance,
>
> << With the EDB Manager, how can I rename a table name?  I imported a
> couple DBISAM tables I wanted to use, but need to rename them for this
> schema. >>
>
> The only way to rename tables at the moment is to create the new table,
> move the data over with INSERT INTO SELECT, and then drop the old table.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Michael,

<< Isn't easy to implement a "Rename" or something ? >>

It is now, but it wasn't when the stored procedures and functions were bound
to the database catalog, which is why it wasn't done for the initial
release.

Remember folks - version 1.00 B1 here.  Give it some time to take shape.

--
Tim Young
Elevate Software
www.elevatesoft.com

Lance,

<< BTW:  I do really like what you did with the UI and the Manager. >>

Thanks.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> << Isn't easy to implement a "Rename" or something ? >>
>
> It is now, but it wasn't when the stored procedures and functions were bound
> to the database catalog, which is why it wasn't done for the initial
> release.
>
> Remember folks - version 1.00 B1 here.  Give it some time to take shape.

No problem about the time. Just wanted to know if you implement it.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< No problem about the time. Just wanted to know if you implement it.
>>

Frankly, I don't know for sure at this point.  My point was that I'm
spending way too much time dealing with "what ifs" while the existing work
that needs done sits there not getting done.  To give you an idea, I spent 7
hours doing email and newsgroup support yesterday, forcing the new EDB build
and DBISAM build to wait another day.

--
Tim Young
Elevate Software
www.elevatesoft.com