🚀 go-pugleaf

You're using the BDE, regardless of ODBC or SQL Links.  BDE Version 5.1.1.1
doesn't work well with Oracle.  Seems like the NULL indicator isn't properly
set.  The column value itself contains garbage characters, therefore the
invalid conversion.  Same is true for NULL VARCHARS, etc.

First, we backed up to a previous version of the BDE SQLORA8.DLL file -
forgot if it was 5.0.1 or 5.1.0, sorry.

Second we got rid of the BDE and converted to ADO - which is what this group
is all about.

Regards,
- Arnie

"Joachim Pfeifer" <jp@alpin.it> wrote in message news:3c7f3666$1_1@dnews...
> i use builder 4.0 professional, oracle 8.1.6 and oracle odbc driver
> or builder 5.0 enterpris, oracle 8.1.6 and sql-links
>
> when i use a simple query to retrieve data from a table, that has a date
> column and cotains
> null values i get the following error:
>
> in case of sql-links usage: invalid time - translate error - value out of
> bounds
> in case of bde usage: invalid datetime format.
>
>
> has anyone an idea?
>
> thanks,
>
> jo.
>
> Joachim Pfeifer
> Alpin srl.
> jp@alpin.it
> +39 0471 568155
>
>
>
>