Re: ADOQuery and decimal fields in Delphi 5...

We are using Delphi Professional 5 and Diamond ADO v. 1.86 to connect a
Delphi application to a MS-SQL 2000 database. Within the database, there is
a table with a field defined as decimal(19, 5).

When we query this table via a ADOQuery (TdADOQuery), the returned value has
only 4 digits to the right of the decimal point. Does anybody know how to
get the correct value back (with 5 digits to the right of the decimal
point)?

If you have BCD enabled for the dataset Delphi will map your Decimal field to a
BCD field which will have 4 decimal places. If you do not have BCD enabled
Delphi will map the field to a tFloat field.
Those are the only choices you have
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Delphi Jobs
    ... I am a Delphi database programmer. ... Source Safe and Source Off Site on the server side and client side. ... design several pieces for the interactive website. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Embarcaderos Director of Products Blog
    ... What indications were there that it was difficult to sell, ... but Delphi has ALWAYS been about database development. ... All of which DO make perfect sense and could be seen as having a home at ...
    (borland.public.delphi.non-technical)
  • Software specifications
    ... I have been frustrated in this project because my software and hardware is ... another programmer who has been my mentor in Delphi, ... me when it will be ready, as they are struggling with old MSDOS software ... could do the entire database project myself, ...
    (comp.lang.pascal.delphi.misc)
  • Database Landscape for future Delphi work.
    ... I'm a died-in-the-wool Delphi fan, and have been programming in Delphi since ... So I switched my database to Jet 4.0 and to using ADO via Delphi's ... Good support for syncing w/ SQL Server. ...
    (borland.public.delphi.non-technical)
  • Re: acucobol
    ... J have not any experience with cobol ... If there is something who let me to acces to this db with delphi j have solved the problem ... Do you in fact need to learn COBOL at all, or are you just interested in getting data from the DataBase to be used with another language. ... If that's the case, dependent upon the DB used in the AcuCOBOL application you should be able to EXPORT the data, and IMPORT the data into the Delphi DB - that might be your solution. ...
    (comp.lang.cobol)