Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Instead of _TALLY
Message
From
01/04/1997 03:13:51
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
01/04/1997 02:41:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00026356
Message ID:
00026361
Views:
44
>reccount()
>
>Arnon
>
>
>>Hello, I am using VFP3.0
>>If I use SQL-select to create a cursor file for reporting, I can know the
>
>>number of record by _TALLY.
>>But if I don't use SQL-Select to create a cursor before do the REPORT
>>command, that say the report definition file directly read on table. Can
>I
>>know the number of record before reporting??
>>

To clarify, reccount() will tell the number of records in the base table. This number includes deleted records. If you apply a filter (like your SQL implies), you will have to COUNT ALL TO in order to determine this count.

Mike Yearwood Toronto, Ontario Canada (co-founder of the Toronto Foxpro User's Group)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform