Inserting Nulls and Date Handling

[David Ward <wardd@MAIL.UWW.EDU>]

Jason -

one thing I've learned is that PS is not consistent when it comes to
'null/not null' definition for delivered date fields.  I have written
programs which read a source date field defined as allowing nulls(null is
the default if no date exists) and then push that field to a date field on
another table which does not allow nulls(date 'value' should be the same
for business purposes).  A null check needs to be made on the source field
before the insertion or an error will occur.

To populate a date field which allows nulls with a null value, why not just
simply omit the field/value from the insert statement?  Works for me.

David.








Date: Thu, 28 Feb 2002 12:12:39 -0500
From: Jason Rupp <jrupp@TECHNEGLAS.COM>
Subject: Re: Insert Error- Date Problem
Arun,
Thanks for the response. I think the problem that I am having is the
default date values. I am not sure how to assign a NULL value. Do you
have any suggestions of what I can do to make the default date values
NULL?
Thanks!







David Ward
Technology & Information Resources
UW-Whitewater
800 W. Main St.
Whitewater, WI  53190
E-mail:  wardd@mail.uww.edu
Voice:   262-472-1039
Fax:     262-472-5733