FMTBCDField problem

[abbath8]

Hi,

I have an Oracle 9i table with a FLOAT field. There is a dbxpress clientdataset I query the table into. If I want to give some value for the float field:

CDatasetFLOATFIELD.AsFloat := <some double variable>

only 4 decimals will be saved with rounding. So when I try:

doublevar := 1.12345678
CDatasetFLOATFIELD.AsFloat := doublevar;

the value of the field will be 1.1235

The field is a TFMTBCDField which supports more than 4 decimals as I know. What is the problem? What do I do wrong?

 

[Zathras]

Look at the EnableBCD property of the TCustomADODataSet.

 

[abbath8]

It's not an ADODataSet, it's a ClientDataset...

 

[abbath8]

When I write:

CDatasetFLOATFIELD.AsString := floattostr(doublevar);

then the field gets the value correctly. Ok this is not a solution, but what is wrong with the AsFloat (or Value as well)??? Why does it round the number to 4 decimals?