BCD Issue in Report Builder

rbuser

D7, RB10.07, SQL

I have an application that uses numeric fields with 5 numbers past the
decimal (precision). I recently converted the application from ODBC to ADO.
When I did, I found that the numeric values would not carry out to 5 digits
past decimal. After working on the problem, I found that it was that the
TADOQuery components had the EnableBCD property set to true. Changing them
to False resolved the issue in my application. However, I cannot figure out
how to resolve the issue in RB. A value of 1.97975 appears in my reports as
1.97980. The raw data is 1.97975. Messing with the DBText Display Property
does not have any effect. I have not seen a BCD property.
How can I disable BCD on the RB Query datasets?

nardmoseley

I would try modifying the Dade plug-in for ADO. In daADO.pas, there is a
class called TdaChildADOQuery that descends from TADOQuery. You can add some
code to that class, either add some code to the SetConnection method or
override the constructor.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Worked perfectly.

Thanks,
Bob