Hi just a guess
maybe there are some formula set in that field table

>Hi!
>
>If i update (or Insert) a numeric field (N5,0) 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.
>
>Any Help wanted!
>
>Greetings from Germany