DESIGNER - Tables in a different schema

From: Claudio BROGGIO <Claudio.Broggio_at_cern.ch>
Date: 2000/07/03
Message-ID: <39609D3E.818D1CBC_at_cern.ch>#1/1


Hi,
I am generating some applications using the WebServer Generator. In one module I have to refer a table (as a look up table) which is in a different schema. It seems there's no way to do it. Or, at least, I don't know how.
As if I had a module about the table:

 PEOPLE (NAME, BIRTHDATE, COUNTRY_CODE) but then the table

 COUNTRIES (COUTRY_CODE, COUNTRY_NAME) is in another schema. Well. I don't have the Server model fo that schema, I tried to create a synonym to COUNTRIES, but Designer doesn't seem to see any synonym.
I'd really like to create a module including both informations (people and name of the country). Any idea? Thanks...
Claudio Received on Mon Jul 03 2000 - 00:00:00 CEST

Original text of this message