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)?

Thanks for your help.


.

Relevant Pages

  • Re: How should I generate a primary key?
    ... the external reality and verify them. ... be verified for syntax or check digits inside itself. ... A surrogate key is system generated to replace the actual key behind ... with a quote from Dr. Codd: "..Database users ...
    (comp.databases)
  • Re: encryption with python
    ... > and a birth date (8 digits, could be padded to be 9) and obtain a new ... quick-and-dirty student ID algorithm: ... I'd check the database to see if the number has ... an attacker might be able to work out roughly what ...
    (comp.lang.python)
  • RE: MS-SQL -> OS DB Migration was Re: idiot database flamewars
    ... Subject: MS-SQL -> OS DB Migration was Re: idiot database flamewars ... > successful migrations from MS SQL. ...
    (Fedora)
  • Default Value of field based on another field of same record
    ... Retirement Default value to be set to last day of the month when age is ... of date Batch field above). ... how can I extract the first four digits from the field 'OfficerID' ... I can post the database if required. ...
    (microsoft.public.access.gettingstarted)
  • Re: Parts Numbering Scheme
    ... >numbering scheme. ... The next two digits indicate a major subsystem or group of related parts ... A big reason why local phone numbers in the US are ... I would create a database to go with this, with the part number as the ...
    (sci.electronics.design)