Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Title:
SQL Update Conflict and Reverse Rounding on the number 6
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only