Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery() makes VFP magic
Message
De
15/06/1998 11:02:19
 
 
À
15/06/1998 08:39:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00108180
Message ID:
00108232
Vues:
42
Hi Benn,

>I have a SQL-Server 6.5 table with a numeric field (10,2). When I enter a value that ends with xxx.35 in my View and run Requery("View") the value changes to xxx.34. No other decimal values change value. ????

Does this only happen with xxx.35? Are you doing any sort of calculations on this data that could cause a rounding issue? On that same topic, why not try to store the value with REPLACE field WITH ROUND(memvar,2)? Maybe there is an internal rounding issue that this may resolve.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform