Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't count values=0 (zero)
Message
From
30/07/2001 09:37:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
30/07/2001 09:34:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00537154
Message ID:
00537157
Views:
21
>Hi all.
>I have a table with an integer field. I have several zero values and several non-zero values. If I issue this command:
>count all for field1<>0 to intx
>I get intx=5 or whatever, but this:
>count all for field1=0 to intx
>gets me 0 records.
>By the same token:
>replace all filed1 with 4 for field1<>0 replaces all non-zero records, but;
>replace all field1 with 4 for field1=0, replaces nothing.
>What am I missing?
>TIA
>Ulises

Your code looks perfectly legal, to me. Perhaps you have to reindex (indices are used automatically, for Rushmore Optimization).

Hilmar.
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
Reply
Map
View

Click here to load this message in the networking platform