Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery() makes VFP magic
Message
From
15/06/1998 11:02:19
 
 
To
15/06/1998 08:39:40
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00108180
Message ID:
00108232
Views:
41
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
Previous
Reply
Map
View

Click here to load this message in the networking platform