Subject Re: [firebird-support] Firebird roundind issues
Author Helen Borrie
At 11:58 PM 2/07/2009, you wrote:
>I know, and this is why i´m asking for an advice on how to store a
>TBcd on the SQLDA structure. TBcd's store precise decimals in Delphi.

Delphi really doesn't do fixed decimal numbers: BCD is a hack that will work as long as you don't need a scale greater than 4. Use the AsCurrency method to cast the Extended value to a Currency variable or into the TField/XSQLVAR directly.

Read the Delphi help for IBX. This is not a Delphi or IBX support forum. You might get a clearer idea by reading Geoff Worboys' article 'Working with Currency and Scaled Numeric Data Types' at www.ibobjects.com/TechInfo.html.

^ heLen ^