Re: Null vs. nothing
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Thu, 31 Aug 2006 00:54:48 GMT
wjdennis@xxxxxxx wrote:
I'm looking at a table with two date/time columns in it. One colulmn
has its Default Value set to Null, the other has nothing in the
Default Value entry. What is the difference between these two
Default Values?
As default value settings (on a DateTime field) there is no difference
whatsoever. DateTime fields can only contain a proper date entry or a Null. In
the case of NO entry in the DefaultValue property the field will default to Null
if Nulls are allowed. Entering "Null" as the Default Value property might make
that more explicit, but the result is the same.
The only time that a Default Value property of "Null" should make a difference
is on a Text field that also allows zero-length-strings.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- Null vs. nothing
- From: wjdennis
- Null vs. nothing
- Prev by Date: ANSI vs Unicode and the character map
- Next by Date: "Shell"ing to Adobe update question
- Previous by thread: Re: Null vs. nothing
- Next by thread: Re: Null vs. nothing
- Index(es):
Relevant Pages
|
