Different database with the same Database Schema,llblgen pro v.5.3 with MySQL

Posts   
 
    
alonsoChen
User
Posts: 30
Joined: 27-Nov-2017
# Posted on: 02-Dec-2017 09:21:39   

Using LLBLGen Pro v5.3 Runtime Framework. Sorry for my mistake:replace firebird embedded with MySQL Server I have a question about there is a database existed. Sometimes the new database created by other software with the same schema. How can I select the specific database?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 02-Dec-2017 10:04:41   

On the same server? When you sync the relational model data by using the Sync feature in the designer, and you connect to the server, you're presented with the relational model data and it should show the additional catalogs on the same server as well (if the user account has access to them of course)

Frans Bouma | Lead developer LLBLGen Pro
alonsoChen
User
Posts: 30
Joined: 27-Nov-2017
# Posted on: 02-Dec-2017 10:17:33   

Otis wrote:

On the same server? When you sync the relational model data by using the Sync feature in the designer, and you connect to the server, you're presented with the relational model data and it should show the additional catalogs on the same server as well (if the user account has access to them of course)

Yes,the same server . Is there any way using the generated code without change from designer? Like using the "select the database.table ..." t-sql cmd.

alonsoChen
User
Posts: 30
Joined: 27-Nov-2017
# Posted on: 02-Dec-2017 13:57:31   

Per call .

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 03-Dec-2017 09:41:40   

alonsoChen wrote:

Per call .

Then use the per-call overwriting in Adapter, the first link above. There's an example in the docs at the link simple_smile

Frans Bouma | Lead developer LLBLGen Pro