Subject Re: Size mismatch for field...
Author fabiano_bonin
So what should i do about this? Are we the only people having this
problem? Why?
I have lots of forms and componentes, so adjust it by hand is not an
option.

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> 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