Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of records in Grid
Message
From
04/03/2008 16:09:00
 
 
To
04/03/2008 15:46:26
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01298593
Message ID:
01298657
Views:
16
>>>I need to know how many records are in the grid. I'm getting odd results on a filtered table that populates the grid so I want to know if there is a way to look at the grid itself and know at runtime. Thanks!
>>
>>If you populate the grid via some SQL select statement, you can use _tally instead of reccount().
>
>Wouldn't _TALLY and RECCOUNT() give the same results?

No, not if the resulting cursor is not a real cursor, but only a filtered table.
Try this
Select * from sometable where somecondition into cursor curdummy && somecondition must be optimizable
?reccount() && Shows the number of records in sometable
?_tally && Shows the number of selected records
Previous
Reply
Map
View

Click here to load this message in the networking platform