Subject | Re: [IBO] Re: DisplayFormat issue - EConvertError |
---|---|
Author | Helen Borrie |
Post date | 2010-11-23T23:11:25Z |
>From: "Joe" <joe@...>At 09:39 AM 24/11/2010, Woody wrote:
>> Woody,
>>
>> It seems to happen no matter which numerical field I put the formatting
>> on. I've tried ITEMCOST, and I've tried ITEMTOTAL (separately, one at a
>> time), and either one will cause the error.
>>
>> Also, the error only occurs if the value in the formatted field contains a
>> fractional (cents) amount. If the field contains only whole dollar
>> amounts (i.e. 1.00), the error does not occur.
>>
>I'm inclined to think it's a compatibility issue somewhere. What databaseBesides saying which fields are causing this problem, also indicate what data type it is (or they are) in the database and how you are casting it (them) in the dataset - including the CalculatedFields! Also, can't see any sign in the DFM that you have set any of these fields as Currency.
>and version are you using?
Helen