Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Values for SQL Server
Message
From
12/05/2004 11:05:15
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Values for SQL Server
Miscellaneous
Thread ID:
00903184
Message ID:
00903184
Views:
69
Hi!

If i update (or Insert) a numeric field (N5,0) via Visual FoxPro 8.0 View on SQL Server 2000 SP3a by value like 480 via remote view, the SQL Server stores a value reduced by 1.
Or if i Store a value like 5000,00 to a field (N14,2) the Server stores 4999,99.

What is the problem? We use the newes Mdac, VFP8.0 SP1.
If I send an Update out of the Sql Query Analyzer etherything is ok. So i think it depends on the VFP Remote view, bud i can't see where the problem is.

There are no rules or so defined!

Any Help wanted!

Greetings from Germany
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Next
Reply
Map
View

Click here to load this message in the networking platform