Modify schema name overwrites at runtime

Posts   
 
    
DarkRoast
User
Posts: 42
Joined: 14-Jul-2010
# Posted on: 22-Sep-2011 20:43:31   

Is there a way to modify the schema name overwrites at runtime? For example, I'd like to use a drop down list containing schema names and enable the user to set the target schema based on a selection from the list.

Using LLBL 3.1 with ODP.Net driver.

Thanks!

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
DarkRoast
User
Posts: 42
Joined: 14-Jul-2010
# Posted on: 23-Sep-2011 06:31:35   

Thanks for all the info. Looks like I forgot to mention an important detail. I'm using Self-Servicing, any hope for me?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 23-Sep-2011 10:00:07   

Use Schema name overwriting and specify an empty string for the schema name. Then set the connection string dynamicaly using:

CommonDaoBase.ActualConnectionString = "......";

The schema/user specified in the connection string is the one that should be used.