Rounding Error in MS SQL Server 
Author Message
 Rounding Error in MS SQL Server

  I am using delphi 2, SQL Link 3.5, MS SQL Serve 6.5.

  I tried the idea from the pros as follows :
 >Using Enable BCD (which is set in your BDE    Alias). You will then
have to change all of your
 >TCurrency    fields to TBCDFields, but you will get better accuracy.
   It seems ok, but when I tried to input some another values to a field
( Decimal(11,7) ), e.g. 12.123456 , I expect, Delphi will store
12.123456
  to my Table, But I found it stored 12.1235 .

  so, What can I do ?
  Pls help me

  Thanks in advance,


--
 /\_/\   /\_/\   /\_/\

  -+-      0       ~



Wed, 18 Jun 1902 08:00:00 GMT  
 Rounding Error in MS SQL Server

Thanks what a "currency" is in real life - 4 decimals.



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Delphi 3.0 - IIS 2/3 ISAPI SQL Server (MS) not found errors

2. BDE/ MS SQL Server error

3. TQuery Hangs on MS SQL Server error

4. Borland Interbase Server vs MS SQL Server

5. MS-SQL server 6.5 vs Interbase server ???

6. Local SQL v.s MS SQL Server

7. SQL Databases - MS Sql Server 7 vs. Interbase

8. SQL Links problem with MS SQL Server

9. MS SQL Server -TCP - SQL Links

10. SQL-Link fur MS-SQL SERVER

11. SQL Links and MS SQL Server

12. MS SQL Server - ODBC vs SQL Links

 

 
Powered by phpBB® Forum Software