Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only