Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting rows in a view
Message
De
15/05/2006 14:49:13
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Deleting rows in a view
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01121965
Message ID:
01121965
Vues:
51
Hi,

I've got a form with a grid on it. The grid is based on a view. the view is opened with table buffering on. I delete a record in the view (simple DELETE command), then press a button that does a TABLEUPDATE(0, .T.), which returns .T.

However, the record does is still there when I open up the form again.

If I SET DELETED OFF prior to the TABLEUPDATE() the record does get deleted!

As this is coming to the end of a very taxing day I would appreciate it if someone can explain to me why SET DELETED OFF makes it work.

Thanks,
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform