Page 1 of 1

ClientDataSets and BCD

Posted: Sun 18 Mar 2012 03:58
by softsmith
Delphi XE2 with SP4
IBDAC 4.1.5

I am unable to access data from BCD fields when I use a ClientDataSet and set the EnableBCD option to true on the IBCConnection.

I have set up the following simple example

With a blank project, and a main form, drop a IBCConnection, IBCQuery, ClientDataSet, Datasource, and a TDBGrid on to it

Set the IBCConnection database to the one that comes with Firebird, Employee.fdb

Set IBCQuery SQL to Select * from Department, and Open the ClientDataSet.
The amounts for Budget field show correctly, but as Floats.
When I set IBCConnection EnableBCD option to true, the amounts are now all zero.

How can I access the Budget field as BCD data with a ClientDataSet, or, is this functionality not supported.

Thanks for any help

Posted: Mon 19 Mar 2012 09:47
by AndreyZ
Thank you for the information. We reproduced the problem and the investigation is in progress. We will notify you when we have any results.

Re: ClientDataSets and BCD

Posted: Mon 29 Jul 2013 09:41
by AndreyZ
We have fixed this problem. This fix will be included in the next IBDAC build.