>>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)
The size of the table is very large, and count all or reccount before report command is time consuming.
Can I get the count by the report command? Any tricks??
oh, what is the fastest way to write good program?