>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

Reply via email to