-----Original Message-----
From: Mark Howard [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 12 August 2000 4:05 a.m.
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Selecting null Dates
Thanks Nello and Patrick
I was not sure if an empty date field was null or something else.
When my
"select * from dockets where mydate = null"
didn't work I was concerned more with the "null" than the "=" Doh! (as they
say).
Thank you for your gracious "I'm sure I am missing something in your
question"!
Mark
>
> >Paradox/D5
> >
> >I have a table with some date fields In some of the records the date
> fields are just as they were when the field >was added to the table - ie
no
> date has yet been saved.
> >
> >How would I SELECT these records, please?
>
>
> I am sure I am missing something in your question - but
> I just tried adding a record to a table with a date field
> (not saving a date value into the date field)
> and - using the DBExplorer - found it using this query:
>
> select * from orders where deliverydate is null
>
>
> If this does not work for you - maybe there is something funny
> in your BDE date configurations.
>
> ns
>
>
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
CAUTION - This message may contain privileged and confidential information intended
only for the
use of the addressee(s) named above. If you are not the intended recipient of this
message you are
hereby notified that any use, dissemination, distribution or reproduction of this
message is prohibited.
If you have received this message in error please notify Progressive Enterprises Ltd.
immediately via
email at [EMAIL PROTECTED] Any views expressed in this message
are those of the
individual sender and may not necessarily reflect the views of Progressive Enterprises
Ltd.
This footnote also confirms that Progressive Enterprises Ltd. has swept this email
message for the
presence of computer viruses. This does not guarantee this message is virus free.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
