Hi!
If i update (or Insert) a numeric field (numeric 5,0 precision 8
) 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 newest 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, formulars or so defined!
I have these problems in every numeric Field in my Database.
I use DSN less connections.
Any Help wanted!
Greetings from Germany