-----Original Message-----
From: Nello Sestini [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 August 2000 5:15 p.m.
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Selecting null Dates
>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
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
