Putting NULL Value in date field using Quick

[Robert J.M. Edis]

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.