I know this is too late to help the original poster, but as a general rule, I believe use of _TALLY is a bad idea. I don't know of anything it gives you that you can't get with a more deterministic (i.e., less likely to give you these sorts of problems) approach. For instance, instead of
COUNT
?_TALLY
I would prefer
COUNT TO lnMyVar
?lnMyVar
Just my 2 cents :)
zahid
>Noted and logged, George. Thanks for spotting it. I'd like to point out that there is nothing wrong with _TALLY in code; this is just a Command Window issue.
>
>
>>Since getting VFP7, we've been seeing _TALLY anomolies.
>>
>>Sometimes when we issue ?_TALLY from the command window, it comes back with 1 or 922. It had been perplexing us until today.
>>
>>We have 922 records in FOXCODE.DBF. If we turn off IntelliSense, we never get erroneous results from _TALLY.
>>
>>Is this new feature (counting IntelliSense in _TALLY results) bothering anyone else?
>>
>>EXAMPLE:
>>If I issue the following commands from the command window:
>>
>>
>>USE v_prod
>>COUNT
>>? _TALLY
>>
>>
>>I get 1 sometimes. There are 2449 records in this table. Subsequent counts return _TALLY of 2449.