Re: Designer6i, Allowable values code table

"Surfnet" <j.r.l.m.bataille#3#_at_uva.nl> wrote in message news:a94taf$1ot$1_at_news.surfnet.nl...
> Hello Susott,
> this table is called cg_ref_codes or <applicationname>_ref_codes. A set of
> allowable values is called a domain. A column can be based on a domain.
> If you generate a table which has a column based on a domain a script is
> generated. In this script you will find a couple of lines that
> - deletes all allowable values for the domain involved
> - inserts the new allowable values for the domain/column/table
> If you edit the generated script and only run this part, you'll be fine.
> The application does not even have to be restarted.
> And the DBA can indeed go in the table and remove unused values, in
> necessary.
>
> There is one property you can consider.
> Designer has some setting for a 'application specific ref codes table'. It
> shows up somewhere in the Generator Options dialog. This would mean that
the
> ref codes table is only to be used by one application. The name of the
> generated table then changes to <app>_ref_codes where app is the three
> letter short name of your application. You can also have a ref codes table
> that is used by more applications; it is then usually called cg_ref_codes.
> This is explained in the online-help.
>
> Hope this helps.
> Regards, Joost
>
> --
> Joost Bataille
> University of Amsterdam ICT centre
> www.ic.uva.nl
>
<SNIP>
So under which circumstances would the cg_ref_codes table be better/more applicable/advantageous to use over a "codes table" manually created? (or would a manually created table have any advantages at all?) Received on Fri Apr 12 2002 - 17:59:57 CEST