Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same app with different bahavior on seperate database
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Same app with different bahavior on seperate database
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00967380
Message ID:
00967380
Views:
70
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 own solution. 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