Ok, bud (i think may be today it is to hot ;-) ) i do not unterstand what this mean!
Do i have now to change the Field definitions on the SQL Server? Which datatype will be the right thing?
>
>You can see the update statement @P2 the value is 1049
>>
>I was sure of this. This is another bug.
>
>The field is N(8,0)?
>
>The value in VFP is 1050?
>
>The implementation of N(x, y) has a sea of problems.
>
>1. When VFP use N(x, y) values for computations, it convert the values into a B(y) value.
>Then,
>
You cannot execute the same calculation in VFP and SQL Server and expecting for the same result to you.>In Practice VFP it does not support the Decimal() data type.
>
>2. It remembers to you that N(x, y) is not a SQL Decimal(x, y):
>
>clear
>CREATE CURSOR testN ( nn N(5,2))
>append blank
>? "valid values"
>REPLACE nn WITH 10.23
>? nn
>REPLACE nn WITH 1234
>? nn
>REPLACE nn WITH -123
>? nn
>REPLACE nn WITH -1.23
>? nn
>
>? "not valid values"
>REPLACE nn WITH -1.233
>? nn
>REPLACE nn WITH 100.23
>? nn
>REPLACE nn WITH -10.23
>? nn
>