Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Open tables of different databases?
Tue, Jul 22 2008 3:17 AMPermanent Link

Francisco Fernandez
Hi, can i open at the same time tables of different databases?

In this case, how? because you can only insert one engine component in the project, isn't it?

Thank you
Tue, Jul 22 2008 4:34 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Francisco


>Hi, can i open at the same time tables of different databases?

Yes

>In this case, how? because you can only insert one engine component in the project, isn't it?

Simply drop more TEDBDatabase's onto the form.

The structure is

1 engine -> many sessions

1 session -> many databases

1 database -> many tables

If you're using TEDBTables then you don't have to bother any further. If you're using SQL you need to keep all the databases you want in a single query under one session (I think) and if you're referencing tables from more than one database in a piece of SQL preface them with the database.

Roy Lambert [Team Elevate]
Image