We have a very strange problem. Our big application written on PowerBuilder, C#, VB and works with Oracle and Mss databases.
The save process to database going by command dscontrol.Update() through array of datastores control. The problem is : for the column type "number" in Mss DB some values saved as user entered them, and some in the different format. For example in application i want to save those values:
but the values stored in the database:
There are some numbers : “-0.97” is stored as "-0.97000003"
“8.98” is stored as "8.9799995".
but the others are ok : “0.96” is stored as "0.96", “0.95” is stored as "0.95", “0.98” is stored as "0.98", “8.99” is stored as "8.99"
This happening through all our application for all the columns type "number". When i try debug this problem in PowerBuilder environment ( or simple run the application from PowerBuilder) i cannot reproduce this problem ( all those numbers saved ok ), but when i working with the exe - it's happening.
Why is this happened? What the problem? Maybe when i working in the PowerBuilder environment my computer has all the files and dll's from PowerBuilder installation and when i am working with exe on the other PC - something missing?
What you can suggest to do, to check?