On Saturday 10 March 2007 14:44, Paul McNett wrote:
> womble wrote:
> > Will the following work?
> > 1. set an applications connection to database A, then create bizObj b1
> > 2. set an applications connection to database B, then create bizObj b2
> >
> > Will b1 and b2 reference the seperate db, or will b1 now reference db B?
>
> If you have two separate connections (nothing stops you from doing that)
> then each bizobj will reference the correct db.
>
> If your two bizobj's share the same connection, then you'll have to
> explicitly qualify the database to be sure. IOW:
>
> biz.UserSQL = "select * from mydatabase.mytable"
>
> instead of:
>
> biz.UserSQL = "select * from mytable"

If you are using Postgres don't forget your schema ;-)
-- 
John Fabiani

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users

Reply via email to