Hi Peter,
>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?It isn't entirely correct because VFP may not have some data type or may store them differently. I woud carefully compare all numeric field formats in a view and in SQL Serrver.
>(BTW, why they'd call money currency in VFP beats me, but I guess it's a big shop :-))$ is money, anything else is currency. <bg>
>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.I would save data before insert and than compare with inserted data in SQL server.
--sb--