Subject | How to keep null dates null? |
---|---|
Author | Clay Shannon |
Post date | 2005-09-02T20:43:24Z |
I have a table with some dates stored as <null>.
However, when I update any changes the user may have made:
if not TryStrToDate(iwedtAdmissionDate.Text, d8Admit) then
d8Admit :=
FIBDatasetCaseEdit.Fields.FieldByName('ADMIT_DATE').AsDateTime;
.
sp.ParamByName('ADMIT_DATE').AsDate := d8Admit;
if the user hasn't made any valid changes (for example, the direct
assignment to d8Admit above is executed if iwedtAdmissionDate.Text = ''),
the dates in question are changed from null to 0 (12/30/1899), so that the
records display that bogus date instead of blank as before when the value
was <null>.
How can I prevent this from happening?
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]
However, when I update any changes the user may have made:
if not TryStrToDate(iwedtAdmissionDate.Text, d8Admit) then
d8Admit :=
FIBDatasetCaseEdit.Fields.FieldByName('ADMIT_DATE').AsDateTime;
.
sp.ParamByName('ADMIT_DATE').AsDate := d8Admit;
if the user hasn't made any valid changes (for example, the direct
assignment to d8Admit above is executed if iwedtAdmissionDate.Text = ''),
the dates in question are changed from null to 0 (12/30/1899), so that the
records display that bogus date instead of blank as before when the value
was <null>.
How can I prevent this from happening?
Clay Shannon,
Dimension 4 Software
[Non-text portions of this message have been removed]