Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting rows in a view
Message
De
17/05/2006 11:55:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
17/05/2006 10:37:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01121965
Message ID:
01122806
Vues:
18
>I think I worked it out yesterday.
>
>I was using a DO WHILE loop around the view and doing a TABLEUPDATE(0, .T.) on each record. Of course if SET DELETED was OFF then the deleted rows would get deleted properly, but if it was ON, then they would get skipped by the DO WHIE and so never get updated!

Perhaps then, you should rather use GetNextModified() to select, one by one, the modified records. I suspect this will include the deleted records, but you will have to test it.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform