Sorry Helen. You are correct. The message is '30.12.1899 00:00:00 is
not a valid date and time'.

Thanks
Wayne


--- In IB-Conversions@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 01:43 PM 24/01/2003 +0000, you wrote:
> >I'm using PdoxPump, developed by Helen Borie, to transfer data from
> >Paradox tables to Firebird version 1. In my Pdox tables I have date
> >fields that may or may not be blank. When running the datapump

using

> >dialect 3, I get the error '30, 12, 1899 00:00:00 is not a good
> >timestamp'. The metadata in the Firebird database for the date

field

> >shows Date NULL. How can I transfer blank dates?
>
> Can you confirm that the message is not " '30.12.1899 00:00:00' is

not a

> valid timestamp " ? That's the standard Delphi message. If you

really are

> getting a message exactly like what you reported above, then it

indicates

> that there is a substitution error in my code...
>
> A date type can't be blank. It can only be a valid date or NULL.

So

> somehow you need to avoid getting Delphi passing "blank date"

as "delphi

> date zero", which is the date you see in those numbers. This isn't

the

> same as Firebird date zero, which is November 17, 1898 - but you

don't want

> that either.
>
> I thought the code of pdox2ib handled that, by calling Clear on any
> datetime field that was blank or zero, to ensure that Firebird gets
> NULL. I will have to take a look at that but please re-check that

error

> message and say exactly what it is.
>
> Helen