General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Showing wrong figures by using remote views....
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only