Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Update Conflict and Reverse Rounding on the number 6
Message
De
16/10/1998 15:43:50
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL Update Conflict and Reverse Rounding on the number 6
Divers
Thread ID:
00147665
Message ID:
00147665
Vues:
61
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
Fil
Voir

Click here to load this message in the networking platform