Considering the record in the view does not contain a primary key value, issueing a REFRESH(1) marks the record in the view as deleted: "If a record in a table does not have a primary key value, the corresponding record in the SQL view is marked for deletion." as stated in the VFP8 help.

I had encountered this behavior even though the underlying table had issued a primary key.


I known this.

But exists only 3 solutions:
- use REFRESH() with a candidate key used like a surrogate primary key
( my post is for this situations )
- use AFIELDS() with the underlying table, but this opens many issues of sharing of gives to you;
- wait for VFP9, where a GETAUTOINC() it resolves the issue ( on simple case only ).