BCD Overflow

[kribo]

Hi,
I have a situation like below:

TUniConnection connected to SQL Server 2000
TUniQuery -> DatasetProvider -> ClientDataset

I have a data table that contains a field with Numeric 5(6,2) data type. If I execute a query against that table like "SELECT * from Mytable", a "BCD Overflow" is returned.

EDIT: "BCD Overflow" shown for that Numeric field when displayed using TDBGrid.

Such a message never occured in the past when I purely employed ClientDataset alone.

How to solve this problem.

Thank you in advance.

[AlexP]

Hello,

I cannot reproduce the problem.
Please specify the following information:
the exact version of SDAC;
the exact version of your IDE;
the TUniQuery, TUniConnection, TDataSetProvider and TClientDataSet properties if they differ from the default properties, or send me a complete small sample to alexp*devart*com..
the script to create and fill a table.

[kribo]

Hi Alex,

I'm still using UniDAC 2.70.0.9 for Delphi 7 Enterprise.

But just a while ago I managed to solve my problem. Found the answer for topic "FMTBcd round issue" in Devart's dbExpress forum. There Dimon told to set EnableBCD = FALSE, so now, only EnableFMTBCD = TRUE in my UniConnection setting, I tested and it worked!

I think a sample to reproduce the problem now is no longer needed, but additional explanation regarding the problem and why it can be solved that way is extremely essential for me and others. Anyway, thanks a lot for your kind respond.

Best regards.

[AlexP]

hello,

You are using quite an old version of UniDAC, in the latest version UniDAC 4.1.6 the error does not occur during work with such fields, regardless of EnableBCD and EnableFMTBCD option values. You can download the latest trial version on our site and check this behavior.

[kribo]

Dear Alex,
Thanks for your suggestion. Definitely upgrading is my priority for the next project this year. Two of my projects already using that old version for years and quite stable. So not easy to re-work them all. Even old it still powerful! you may proud of that.

Best regards,