CREATE SQL VIEW VIEW1 REMOTE CONNECTION Connect1 AS SELECT * FROM TEST INDEX ON ALLTRIM(Field1)+ALLTRIM(Field2) TAG key1 ADDITIVE ? CURSORSETPROP("Buffering", 5) ? CURSORSETPROP("Sendupdates", .T.) FOR i=1 TO 5 m.Field1="A"+ALLTRIM(STR(i)) m.Field2="B"+ALLTRIM(STR(i)) m.sumvalue=i IF NOT SEEK(m.Field1+m.Field2,"View1","Key1") INSERT INTO View1 FROM MEMVAR ELSE REPLACE View1.SumValue WITH View1.SumValue+1 ENDIF ENDFOR ? TABLEUPDATE(2,.T.)While something like this works with row buffering and a TABLEUPDATE() right after the Insert or Replace, an ODBC error about not being able to insert empty rows in a views base table occurs with buffering=5.