Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting rows in a view
Message
From
17/05/2006 11:55:56
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/05/2006 10:37:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01121965
Message ID:
01122806
Views:
14
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform