Re: Des2000: using functions in domains

From: Jeff Jacobs <jmjacobs_at_ix.netcom.com>
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

Original text of this message