>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