At 10:47 PM 30-01-01 -0600, you wrote:

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

Right-click on the IBOQuery component to bring up the fields editor. If
the persistent fields aren't there, get them. Check that the field object
is the type you expect, e.g. TIBOBCDField. It's probable that the
precision is too low for Delphi to determine how to cast it correctly. You
may be able to help it by casting it manually to the Delphi field type you
expect. If it's a currency column, numeric(9,2) is too low anyway.

Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________