Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Same app with different bahavior on seperate database
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Same app with different bahavior on seperate database
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
00967380
Message ID:
00967380
Vues:
56
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)
Répondre
Fil
Voir

Click here to load this message in the networking platform