Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Update Conflict and Reverse Rounding on the number 6
Message
From
16/10/1998 15:43:50
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL Update Conflict and Reverse Rounding on the number 6
Miscellaneous
Thread ID:
00147665
Message ID:
00147665
Views:
60
This is a strange one and I'm thinking that one of our SQL base tables must be corrupt. If we open the database, use the table and change the value in one specific column (numeric, changed recently from two to three decimal places) it works fine. Now the catch; when we enter a .600 or .060 into the same column, it changes the value to .599 or .059 respectively. You then get an update conflict message and have to revert. This does not happen with other values or on other columns in this or other tables. What is going on?!

Thanks, Renoir
Reply
Map
View

Click here to load this message in the networking platform