Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread ElevateDB Manager can see but vcl not
Sun, Sep 30 2007 9:31 AMPermanent Link

Sergei Safar
Hi All,

after a successfully migration from DBISAM 4 to ElevateDB, my ElevateDB Manager can see and open all tables, but all TEDBTables from my project could not find the tables at design time.
I guess every configurations is fine as follows:

- TDBEngine ConfigPath is the same as Manager File Folder / Configuration File
- I can select the database from combo Database property of TEDBDatabase
- There is a TEDBSession and RemoteHost is "Local"
- Database Name and Session Name of all the EDBTables as correctly set

but TableName property if all TEDBTables is always empty.

I am doing something wrong, of course. Any hint here ?

Regards,

Sergei Safar
Sun, Sep 30 2007 11:12 AMPermanent Link

Sergei Safar
Ok, I got it. I was working with 2 diferent catalogs.

Now I need to add an existing table to a Database.
I noticed that copy the physical table to the desired database folder is not enough, so how to add a, existing table to a database ?  

Regards,

Sergei Safar
Mon, Oct 1 2007 4:10 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sergei,

<< Now I need to add an existing table to a Database. I noticed that copy
the physical table to the desired database folder is not enough, so how to
add a, existing table to a database ? >>

Reverse-engineer the existing database using the EDB Manager, and then run
the resultant CREATE TABLE statement for the table that you wish to copy on
the new database.

http://www.elevatesoft.com/edb1sql_create_table.htm

Then use the INSERT INTO .. SELECT statement to insert all of the rows from
the existing table into the new table.  If you are executing the INSERT
statement from the new database, then preface the SELECT table name with its
database name, or vice-versa if the opposite is true.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image