Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Showing wrong figures by using remote views....
Message
From
08/10/2006 23:09:12
Aye Mya Thida Kyaw
Ingenuity Microsystems Sdn Bhd.
Kuala Lumpur, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Showing wrong figures by using remote views....
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01160440
Message ID:
01160440
Views:
51
Dear All,

I'm having a problem as below...
When I saved my transacion, It's saved to SQL Database correctly.
But the problem comes when i call back that transaction to modify.
If the figure is 2345.80, in the text box or grid of my program show me only "2.0". But in the actual table on SQL Server, the figure is still correct as 2345.80.
Seems like all the rest of the digits were trimmed or rounded in my program.
I'm using remote views and the value's data type is Numeric(20,4) in both view's property and SQL site.
I still cannot find the error point to solve this funny problem.
Hope someone can help me figure out of this. Plz....

Thanks a lot in advance,
Mya
Next
Reply
Map
View

Click here to load this message in the networking platform