Hi All.
VFP6.0-Remote View -> MS SQL6.5
A remote table with N(1) type field.

use Remote_View && optimistic row buffering
replace myField with 1 && myField = 1
TableUpdate(0,.t.)
Refresh(1) && !!! myField=2

To sum up: all the values in 1-8 range are increased by 1 before being saved to the underlying remote table. 0 and 9 are saved correctly.
To solve the problem i had to change the width of the field from N(1) to N(2). Not before, mind you, rebuilding the whole table. Thank God it was only a test table.

Excuse me, All, is it OK to post messages like this one?
Maybe everybody is fed up with this kind of reports.

Some time ago we on the Thread were asked about the title of a chapter we would like to add to a book about VFP. How about Relaxation Technique For Repetitive Glitch Disorder Victims. :)

Best wishes to All.