With IB6/Firebird and Dialect 1, I found that changing Numeric(9,2) to
Numeric(9,3) cured a lot of problems.
John

-----Original Message-----
From: Corey Wangler [mailto:cwangler@...]
Sent: Tuesday, February 06, 2001 1:37 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Unsupported Column Conversion


It might pay to do a test on IB5.6 and see if the problem
disappears... numerics give problems under IB6 dialect 1.

I'd recommend going to dialect 3 if you use IB6 or firebird,
as there are some bad problems when running in dialect 1 that
give wrong results for numeric calculations...

[Bug #121589] numeric fields and mathematical operations
https://sourceforge.net/bugs/?func=detailbug&bug_id=121589&group_id=9028

HTH,
Corey.

====================================
Jason Wharton wrote:

>
> Any progress on resolving this item? I am still uncertain what I can do

from

> here.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: "Don Gollahon" <dlgllhn@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, January 30, 2001 9:47 PM
> Subject: [IBO] Unsupported Column Conversion
>
> > I'm using IBOQuery and one of my fields keeps getting the error
> "Unsupported
> > column conversion" after I enter a value and try to move off of the

field.

> > It is defined in IB as Numeric(9,2). I'm using a DBGrid to edit this
> table.
> >
> > IBO version is 3.6. Delphi 4. IB 6. Dialect 1.
> >
> >
> > Don Gollahon
> > (dlgllhn@...)
> > "What in Eternity does it matter?"
> >
> >
> >
> >
> >
>