Re: multiple databases in forms

> I am setting up an application in wich not all screens connect to the same
> database. The method i use is making public synonyms in datbase "A"
> containing a database link to objects in database "B". The databse link
> used connects to a user who has the apropriate rights in database "B". The
> users who use tha application connect to database "A".
> This construction works if the screen that uses database "B" is directly
> started by a user that connects to databse "A". However, if we call the
> screen that uses database "B" from a form that uses database "A", the
> trouble starts, i.e. the screen (the one that uses database "B") never
> appears or that screen disappears after pressing a button.
> Databases are both in version 7.3.2.3.0, forms version is 4.5.

I've not done this in the version you are using but one solution would be to create views/snapshots in database "A" of "B" and visa versa.

Daniel A. Morgan Received on Wed Jul 07 1999 - 00:40:57 CEST