Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same app 2 databases and different behavior...
Message
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Same app 2 databases and different behavior...
Miscellaneous
Thread ID:
00967381
Message ID:
00967381
Views:
51
This message has been marked as the solution to the initial question of the thread.
Hi,

I'm using the same application on two different SQL databases. The problem appear when editing a numeric field of lengh 5, Precision 6 and scale 2.

When connected on the first database, if I enter and save a value of 19.50 it will keep it.

When connected on the second database, if I enter and save a value of 19.50 it will round it to 19.00.

The behavior only appear in the app and the same app is used on both databases. When editing directly in the database the numeric field behaves OK.

I found my problem. Thanks anyway
Luc Nadeau
lnadeau@neova.ca

"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)
Reply
Map
View

Click here to load this message in the networking platform