Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPD25 - REPLACE ... WHILE ... is ALL reqd.
Message
From
06/03/2003 05:42:30
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00761380
Message ID:
00762040
Views:
36
>Without ALL it randomly misses to REPLACE the logical value with .T., though the percentage is very low 2% say. But as the records are not registered=.t. they get deleted next time round (my logic) messing up the whole data integrity.
>
>
SEEK m.id
>REPLACE dbf.registered WITH .T. WHILE dbf.id = m.id
> ...

I was forgetting: the logical keyword in this case would be REST instead of ALL. That means, "from this point on, until the end of the file (or until the WHILE condition fails)".
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