Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Recife - PE - Brazil
    Posts
    28

    Lightbulb Unanswered: Someone can give a litgh? - Field Type

    Hi Everybody,

    In a table there´s a field for store real values,
    so...in 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?
    Thanks for attention

    Leonardo Almeida

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Thumbs up Someone can give a litgh? - Field Type Reply to Thread

    Welcome form the Brazil, It appears that your result are being converted in Delphi via an ADO conection. I dont think this is a SQL problem but this can be handle on both software end. If your results are what your looking for to be the same. I would look into what the conversion process is with Delphi via an ADO conection. Or if you want it hard codet in SQL change the field format. Not a serman, Just a thought.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Floating point numbers are like that. I'd recommend that you switch to the decimal datatype instead.

    -PatP

Posting Permissions

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