Hi Sergey!

At Thist: Thank you for your answer!!


Column: pimzterminanfang numeric 5,0 precision 8

If i look into the SQL Profiler Log, the value has been reduced:
In the Form i entert a value by 1050
The SQL Profiler Log:

exec sp_executesql N'UPDATE pim SET pimdterminanfang=@P1,pimzterminanfang=@P2,pimdterminende=@P3 WHERE pimlfdnr=@P4 AND pimdterminanfang=@P5 AND pimzterminanfang=@P6 AND pimdterminende=@P7', N'@P1 datetime,@P2 numeric(8,0),@P3 datetime,@P4 char(10),@P5 datetime,@P6 numeric(8,0),@P7 datetime', 'Mai 13 2004 12:00:00:000AM', 1049, 'Mai 13 2004 12:00:00:000AM', ' 112000697', 'Mai 13 2004 12:00:00:000AM', 1108, 'Mai 13 2004 12:00:00:000AM'

You can see the update statement @P2 the value is 1049

what could this be?


>Hi Jörg Schneider,
>
>What's columns data type, scale and precision on SQL Server in both cases? You can use SQL Profiler to see what was actualy sent from VFP to SQL Server. It may help you identify the problem source.
>
>>
>>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!