Hi Aleksey,
I certainly missed the part in the VFP docs saying that RECALL does not work with views - can you point me to that part of the docs?
On the other hand, if RECALL is not a SQL command, shouldn't it be disabled, or generate an error when used with a view?
Thanks.

>>I was getting duplicate keys in an app using an updateable local view to update a free table. Yesterday I discovered that recalling a deleted record in a view DOES NOT RECALL the record in the base table, but actually creates a new record, a duplicate!!!
>>
>>Unless I missed something, this makes updateable views not only useless, but extremely dangerous.
>>
>
>Hi Dory,
>
>You missed a very important detail - local/remote view is a SQL VIEW. RECALL is not a SQL command. In VFP, SQL view modifies a base table using SQL-DELETE, SQL-UPDATE, SQL-INSERT, none of those commands recalls deleted records.

>
>Thanks,
>Aleksey.