Helen,

Sorry I have not replied to this in a while. These are old
reports that haven't been changed lately. That is why they
are using TBCDField, when they where created that is what
the field editor inserted them as. It is just when upgrading
to the newest version of IBObjects that we started having
problems if we went and rebuilt the pages. It was an easy
fix to change the size properties. We only had a few form
with the problem.

Thanks
Michael L. Horne


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Thursday, January 22, 2004 6:07 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Size mismatch for field...


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


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/