>did you configure it to send updates on key fields as well..
Yes. Without this, updates to "old" records wouldn't happen I suppose.
I tried to extract problem to a short programm. Here's a setup code of it:
PRIVATE err, tustat
CREATE DATABASE try
CREATE TABLE items (Name C(20), id c(10))
INDEX ON id TAG id
=CURSORSETPROP('buffering',5,'items')
CREATE SQL VIEW v_items AS SELECT * FROM items
=DBSETPROP('v_items', 'View', 'Tables', 'items')
=DBSETPROP('v_items', 'View', 'WhereType', 1)
=DBSETPROP('v_items.nazwa', 'Field', 'UpdateName', 'items.nazwa')
=DBSETPROP('v_items.id', 'Field', 'UpdateName', 'items.id')
=DBSETPROP('v_items.id', 'Field', 'KeyField', .T.)
=DBSETPROP('v_items.nazwa', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items.id', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items', 'View', 'SendUpdates', .T.)
_________________
*|| Andrzej [NJ].