Re: Designer/2000 R2.1: Properties in Red font

Property colors are controlled in the "Options" menu (used to be Edit -> Preferences in R1.3.2).

"Red" properties are mandatory properties, e.g. cannot be NULL. Red is also used to indicate that there is something incorrect in the property's value.

The "format" property for an attribute will override the property in the domain. Bad idea, however. The "format" property (and the datatype property) are initially copied to the attribute when the attribute is assigned to a domain. However, if you change the domain's "format" property, you must run the "Update Attributes in Domain" utility to get them back in synch.

Attributes of type CHAR become columns with datatype of VARCHAR2, as you don't really want columns of type CHAR in Oracle.

Adrian Klingel <klingela_at_NOSPAMnt.com> wrote:

>I'm looking at the properties of my entity attributes in the RON. Does
>anybody know why some of them are listed in red? I've got tons of
>domains defined, and I've noticed in several of my domains that the
>attribute format does not agree with the datatype which will appear in
>the server model, e.g. the attribute format will be CHAR while the
>datatype will be VARCHAR2. Is this the reason?
>
>Also, if I set an attribute format in the RON for an object that is
>based on a domain, will the new value override the domain setting for
>that property?
>
>I'm drawing alot of functional correlations between Designer/2000 2.1
>domains and Developer/2000 2.1 object libraries. I appreciate any
>answers that anyone has.
>
>Thanks,
>Adrian Klingel
>

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com Received on Tue Jul 14 1998 - 19:25:34 CEST