I was just trying several things trying to get it to work. I just forgot to
go back and set it all back before I emailed the example.

We are on Delphi 5 here at work. Planning to upgrade to Delphi 8 this year
when it is released. I have Delphi 6 at home though. I thought I had done
this in Paradox before but after Sean's note it jogged my memory and we had
done the cast to double at that time when we found out the numeric didn't
work.

No big deal. We don't use the BDE in our app, just IBX. It's just nice to
run things in Paradox now and then since I can get quick reports. If we
stick with Firebird I'm hoping I can talk management into using FIBPlus or
IBO since IBX will not remain compatible in the long run.

Thanks, everyone, for your help.



"Helen Borrie" <helebor@...> wrote in message
news:<5.1.0.14.2.20030318091728.0a0d6128@...>...

> At 03:43 PM 17/03/2003 -0500, Sean Leyne wrote:
> >Don,
> >
> >
> > > When I call it from Paradox (or any BDE utility) using:
> > >
> > > Select *
> > > from TAS_EXTRACT('2/10/2003')
> >
> >The BDE is not compatible with Dialect 3 Numeric/Decimal columns!
>
> While I agree that it's the 64-bit incompatibility that is causing this
> problem, I believe that the BDE 5.2 InterBase driver (as shipped in the
> final Delphi 6 update and apparently not available as a separate product)
> *does* support it. It's a detail, though - Paradox doesn't support 64-bit
> numerics.
>
> Don,
> I'm mystified why you are grabbing the MINUTES summary, casting it to
> (15,2) and then pushing it into an (18,2) variable. Your solution here
> might be as simple as changing that variable to (15,2).
>
> heLen
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>