Unanswered: Someone can give a litgh? - Field Type
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
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.