Subject RE: [IBO] Size mismatch for field...
Author Helen Borrie
At 05:22 PM 22/01/2004 -0500, you wrote:
>Jason,
>
>We have run into this problem several times also. It can be
>solved by changing the "Size" properties of the "TBCDField" from
>4 to 2.
>
>It seems to appear when an old TIBOQuery has had fields defined
>by the "Fields Editor". It use to store "4" but now IBO seems
>to require it to be "2", or maybe it is firebird.

4 is just the default for TBCDField. If the database column is
numeric(n,2) then it can't have 4 places in a BCD field - hence the
mismatch. The Precision (sic) property of the BCD field should be set to
match the Scale of the numeric or decimal column.

Don't you use TIBOBCDField?

Helen