Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with a View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00293053
Message ID:
00293174
Vues:
22
>If I delete a record in a buffered updateable view and then do a tablerevert on the view the record in the base table doesn't get reverted...in other words it is still deleted. Why is this? Am I doing something wrong?

If you delete a record in a view, do a TABLEUPDATE() (or move the pointer if the view is record buffered), then the deletion is written to the table. Doing a TABLEREVERT() does nothing after the changes are written.

?Also If I delete a record in a view the record is still displayed in my grid even though I have set deleted on. How can I get the record in the view to not show after it is deleted?

You have to move the record pointer off of the deleted record, and it will disappear from the grid.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform