Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement