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
