Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Recife - PE - Brazil

    Lightbulb Unanswered: Someone can give a litgh?

    Hi Everybody,

    In a table there´s a field for store real values, the database, using the SQL Server Enterprise Manager
    and execute query as 'select * from' and it return the value
    '15,35' just like stored before, why using Delphi via an ADO conection
    in my result set there is a '15,3500003814697' value if in the record time
    the inputed value was '15,35'?
    What I have doing wrong?

  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    From Books Online:

    Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented.

    This is why you NEVER use float or real for exact numbers, such as Accounting or inventory.
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts