Re: CG_REF_CODES

From: Mike Openshaw <openshaw_at_airmail.net>
Date: 1996/10/31
Message-ID: <5596c9$s3v_at_library.airnews.net>#1/1

Andrea Peterlongo <Andrea.Peterlongo_at_ismaa.it> wrote:

>I have tried to create CG_REF_CODES using UTILITIES/GENERATE REFERENCE
>TABLES of Designer/2000 but the table is always created on the database
>where D2K is installed, say A, instead of being created on the
>application database, say B. So when I try to generate any form I get
>error ..'CG_REF_CODES' must name a table to which user has access.
>Could anybody tell me if there is a preference to set to tell D2K
>to create CG_.... on B database (I would like not to grant any privilege
>on database A to the user of datgabase B!).

If worst comes to worst, export then import the CG_REF_CODES table. Another problem we had was the need to manually define a public synonym for the CG_REF_CODE table; Designer/2000 doesn't. Michael B. Openshaw

---

Data != Information
Information != Knowledge
Knowledge != Wisdom Received on Thu Oct 31 1996 - 00:00:00 CET