>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.