| View previous topic :: View next topic |
| Author |
Message |
lwl
Guest
|
 Posted: Wed Apr 14, 2004 2:02 am Post subject: numric field problem |
 |
|
I'm using Delphi 5 and SQL Server 2000; my problem appeare when
posting data to a numric field from delphi using BDE and SQLlinks; rounding
some value happen with no reason (at least for me). here is some example
64.99 become 64.98
127.99 -> 127.98
I don't know why it is! I need help!
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Wed Apr 14, 2004 3:20 am Post subject: Re: numric field problem |
|
|
You should use ADO, not the BDE, with SQL Server 2000.
The BDE SQL Links driver uses Microsoft's DBLIB client library which
Microsoft has not updated since SQL Server 6.5. One of the results is
that the BDE SQL Links driver treats numeric fields as floating point.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
quinn wildman
Guest
|
| Posted: Wed Apr 14, 2004 5:56 pm Post subject: Re: numric field problem |
|
|
Setting enable bcd=true might resolve the problem.
lwl wrote:
| Quote: | I'm using Delphi 5 and SQL Server 2000; my problem appeare when
posting data to a numric field from delphi using BDE and SQLlinks; rounding
some value happen with no reason (at least for me). here is some example
64.99 become 64.98
127.99 -> 127.98
I don't know why it is! I need help!
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
