Subject RE: [IBO] retrieving size and precision of numeric fields
Author Helen Borrie
At 10:45 AM 9/06/2003 +0200, you wrote:
>Hi Helen, I am using IBO V 4.2d. When opening the query and adding the
>fields, the returned types are TBCDField and not TIBOBCDField.
>Is there an option that I can set to make it return TIBOBCDField?

Hmmm, yes, I rarely use dataset-compatible comps and I hadn't really
noticed that it doesn't return TIBOBDCField; and I'd forgotten that you
can't change the field type of TField as you can with TParam.

So, back to original problem. Forget about the Precision property of
TBCDField, or set it to the precision of the stored number. It only seems
to matter for databases that store precision > 20 (which doesn't include
Fb/IB). Use the Currency property set to True instead. This will represent
your value with the required two digits and it should pass correctly over
to the TClientDataSet. If not, post back here and tell us.

The Currency property causes the display to default to '$9,999.00' but you
can change that to whatever format you want.