>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement