Hi Sergey,

In a remote view all fields automatically have the characteristics of the remote table, i.e integer=integer, money=currency a.s.o. Right? I hope?

(BTW, why they'd call money currency in VFP beats me, but I guess it's a big shop :-))

I have no clue to what's going on here, but the error (ODBC) occurs during a tableupdate. The update seems to go through, and once saved, subsequent changes to the record do not trigger it.

It seems to me, that all I'm doing, is writing some values to the backend, so I'm more than a little puzzled.

BR

Peter


>Hi Peter,
>
>A fractional truncation occurs if any mathematical operations on integers generates result with fractional part. The fractional part is trancatiod, not rounded. For examle,

>5 / 2 = 2.5 -> 2
>3 * 0.3 = 0.9 -> 0

I'm not sure how it's related to your situation, though.
>
>>I'm running VFP 8 Remote views against a SQL Server 2000 DE via ODBC and get the above error.
>>
>>How do I determine which field in the server db does the complaining?
>>
>>Why does it complain?