We help IT Professionals succeed at work.

How does one enable Delphi TBcd (ftBcd) fields using the MSSQL 2016 database

Medium Priority
187 Views
Last Modified: 2019-05-26
The Delphi IDE creates ftFloats and I would prefer ftBcd and Currency data types.
Comment
Watch Question

Geert GOracle dba
CERTIFIED EXPERT
Top Expert 2009

Commented:
the bde is not used anymore
try another connection component

http://docwiki.embarcadero.com/RADStudio/Rio/en/BDE
Calvin DayEngineer, Programmer

Author

Commented:
I need BCD not BDE.
Engineer, Programmer
Commented:
It turns out that right before post, some float calculations were causing rounding errors where values were being stored in partial cents. I simply properly rounded those values to the nearest cent and rounding errors went away.