Hi Ralph,

I cant see any response to this on the list, so I am presuming you did
not get one.

> i am having certain problems using
> the Displayformat/Editformat properties
> with TIBOQuery.
>
> code Sample:
>
> InComingPaymentAMOUNT_PAID.DisplayFormat := ',0.00';
> InComingPaymentAMOUNT_PAID.DisplayFormat := '0.00';
>
> aFloatValue := 100000;
> //
> // the following line raises an EConvertError
> // like '100.000,00 is not a valid floating point value ...'
> //
> InComingPaymentAMOUNT_PAID.AsFloat := aFloatValue;
>
> Currently i am using 3.6Di.
> Is it a known issue ?
> Am i misusing the properties ?
> Any workarounds ...

At the moment IBO sets the DisplayFormat values from the
TIBOQuery.FieldsDisplayFormat property. (String list of field=format
entries).

I think what may be happening is that your TField object is providing
a string using one format, where the internal query and column objects
are using a different and incompatible format. By using the
FieldsDisplayFormat property on the query you will hopefully avoid
this problem.

Geoff Worboys
Telesis Computing