Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
ElevateDB Manager can see but vcl not |
Sun, Sep 30 2007 9:31 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |