Putting NULL Value in date field using Quick

[Dan Osborne]

Actually you can specify in the pdl database definition ...

                 default date is null
                 null values not allowed

Works beautifully for 7.33 & Oracle on UNIX.

You get nulls for dates and spaces or 0 for all other data types.

Dan Osborne
Specialist Business Solutions

> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Robert J.M. Edis
> Sent: April 28, 1999 9:40 PM
> To: 'rjhaack@trillium-or.com'
> Cc: 'powerh-l@lists.swau.edu'
> Subject: re: Putting NULL Value in date field using Quick
>
>
> G'day Robert
>
> I believe the only way to put a NULL in your Oracle 7.3 date column is to
> create a trigger for each column.  PowerHouse will default the
> date value to
> zero if no valid date is entered.  The Oracle trigger must check for the
> zero and replace the value with a NULL before inserting or updating the
> record in the table.
>
> Blue
> PowerHouse consultant
> Rhode Island, USA
>
> Disclaimer:
> The opinions and ideas expressed in this message are my own and have no
> relationship to my current employer, Initial Technical Staffing,
> its client
> CCI, or any of CCI's clients.
>
> Original Message
> ------------------------
> From: Robert J Haack <mailto:rjhaack@trillium-or.com>
> Newsgroups: cognos.support.powerhouse
> <news://pubnews.cognos.com/cognos.support.powerhouse>
> Date: Tue, 19 Jan 1999 14:25:47 -0800
> Organization: Trillium Technology Inc
>
> 	We are using Oracle 7.3 and PowerHouse 7.33D on an HP9000 machine.
> We
> 	have a date field that we need to put a NULL value in, but when we
> try
> 	it puts in 00-DECEMB in this field.  Is there anyway to force Quick
> to
> 	put a NULL in this field?
>
> 	TIA
>
> 	Robert Haack
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.