Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT * and SELECT COUNT(*) - different results
Message
From
12/05/1998 03:19:59
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Poland
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00098482
Message ID:
00098676
Views:
28
>There was just another thread on this topic. To find the number of records in a SQL-SELECT cursor you use _tally. RECCOUNT() is for physical tables not cursors. Rushmore may implement a cursor as a SET FILTER if that's the fastest way to do it.

I've read the topic but it isn't about. I'm not misinterpreting _tally and reccount(). The problem is that the same select (SELECT COUNT(*)) returns two different results - depending on the exsistence of 'deleted' tag.
_________________

*|| Andrzej [NJ].
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform