At 01:37 PM 27/01/2003 +0000, you wrote:

>Helen, the message is '30.12.1899 00:00:00 is not a valis date or
>time'.
>
>Have you had a chance to review your code?

Yes; and I've implemented a fix that should post NULL for any date literal
coming through with a length < 8 --- as long as the above error occurs
during the parsing of the Paradox date field and not during the BDE query
on the table, when the BDE is validating the data against the field
type. The Paradox Pump program itself can't fix invalid data errors in the
Paradox table.

The error won't have occurred where a blank date was stored in the Paradox
table, but where 0 was stored. However, the fix should take care of
either. The recompiled program is at

http://www.ibobjects.com/welmore/ParadoxPump.zip

cheers,
Helen

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>IB-Conversions-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/