Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing with For clause.
Message
 
To
18/08/1998 09:38:28
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00127699
Message ID:
00127708
Views:
28
>>Hi,
>>
>>I have a huge table. Before data processing I create temporary index:
>>
>>Select 0
>>Use SERV
>>Index On ENUM+STR(SNO,2) For BATCHDATE=ldDate To Temp
>>
>>How can I know how many records were filtered ?
>>
>>Sincerely, Igor Gelin
>
>Normally _TALLY will return it after INDEX. However, it was reported recently that it's not reliable, so you can fortify it by using COUNT or SELECT-SQL with _TALLY.

Thanks, Ed.

What makes _TALLY un-reliable in this particular case?
Igor Gelin.
Igor Gelin
Database Developer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform