Hi Micheal, Do you have any code to share that shows how to change the data base connection information of the model on the fly?
On 20/12/2012, at 18:01, Michael Gargano <[email protected]> wrote: > yes, I'm doing that now. just be aware that cross db joins are a b*tch. if > there are to many relations to join across you will quickly hit limitations > with IN clauses (which will be your best friend). unless someone else has > come up with something more clever than what I'm doing > > -Mike > > On Dec 20, 2012, at 6:45 PM, Miguel Torres <[email protected]> wrote: > >> Hi list, >> >> We are developing an ERP application. >> We want to use the following approach: >> >> One database to storage users, access control rules, application >> configuration and an enterprises catalog. >> >> For each enterprise we want to set up a different database. >> >> For example: One ERP controlling information of two enterprises would need >> three databases: >> ApplicationDatabase >> EnterpriseOneDatabase >> EnterpriseTwoDatabase >> >> We are doing this because we believe this is more efficient in the long term >> with clients that have more than one enterprise. >> >> We have two Data base Models in the application >> >> ErpApplicatioEOModel >> ErpEnterpriseEOModel >> >> The main page is a Login form where the user selects the Enterprise she >> wants to work with. After the user logins successfully we want to set the >> database connection information in the ErpEnterpriseEOModel. >> >> Is that possible? >> >> >> Thanks in advanced. >> >> Saludos, Miguel Torres. >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/mgargano%40me.com >> >> This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
