Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Instead of _TALLY
Message
From
01/04/1997 07:59:32
 
 
To
01/04/1997 03:13:51
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00026356
Message ID:
00026368
Views:
39
>>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform