Re: Des2000: using functions in domains
Date: 1996/04/05
Message-ID: <31659656.15614418_at_nntp.ix.netcom.com>#1/1
SYSDATE isn't a function, and you can't use function calls in valid values.
Try putting "sysdate" in upper case; this might or might not work, as SYSDATE is recognized by the generators for default values creation, but not sure about the DDL generator.
Matt Stahl <mgstahl_at_sonalysts.com> wrote:
>Using Designer 2000, I'd like to be able to define
>a domain called VALID_DATE. The VALUE attribute of
>allowable values would be a constant, but the
>HIGH_VALUE would be the function sysdate.
>
>When you generate the SQL DDL for a table using the
>VALID_DATE domain, the resultant check constraint
>puts single quotes around sysdate:
>
>CHECK ( <column_name_here> BETWEEN '01/01/1901' AND
>'sysdate' )
>
>Obviously, one could go in and manually remove the
>single quotes from the DDL, but that defeats the
>purpose of designer. Is there a way to use a
>function as an allowable value?
>
>Since I'm on the allowable values topic, is there
>any way to define HIGH_VALUE without specifying
>VALUE? (ie I don't want to define a range of
>values; rather, I want no lower bounds only upper
>bounds)
>
>Thanks in advance,
>-Matt
>--
>Matthew G. Stahl | EMail: mgstahl_at_sonalysts.com
>Analyst | Voice: (860) 442-4355 x 112
>Sonalysts, Inc. | Fax: (860) 442-5080
>=================================================
>All opinions expressed are purely my own and do
>not reflect those of Sonalysts, Inc.
>=================================================
-JJ
Jeffrey Jacobs & Associates
Oracle Designer/2000 Consulting & Training
951-2 Old Country Road, Suite 119, Belmont, CA 94002
Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456
Internet: 76702.456_at_compuserve.com
Received on Fri Apr 05 1996 - 00:00:00 CEST