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 ).
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only