Hello,

can anyone explain me the difference between BCDFields and FMTBCDFields.
In our MySQL Database we've Fields with the DataType DECIMAL(12,2). In some ADQuerys the Fields are shown as BCDFields an in other once as FMTBCDFields.
MYSQL Fields with the dimension DECIMAL(20,8) are always shown as FMTBCDFields in ADQuerys.

We use the Delphi7 IDE.

thx in advance.

Best regards
Maddn

Hello Maddn,

Thank you for the inquiry.
AnyDAC determines the field type depending on FormatOptions properties: MaxBcdPrecision and MaxBcdScale:
www.da-soft.com/anydac/docu/uADStanOptio...MaxBcdPrecision.html
www.da-soft.com/anydac/docu/uADStanOptio...ons_MaxBcdScale.html

The difference between these types (Bcd vs. FMTBcd) is in the way the field data is internally stored and converted. FMTBcd field data type is supposed to be used for numeric/decimal fields with the large precision and scale values.

Please let us know if you need more infromation on this matter.