Thanks Helen for your response and your expertise in creatign such a
great utility. However, when I try to access
http://www.ibobjects.com/welmore/ParadoxPump.zip I get Page cannot be
found. Can you ck the address and advise?

Thanks
Wayne

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

> 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
>
>