Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I check for the number if recods in a table?
Message
 
To
04/11/1997 19:54:01
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00058136
Message ID:
00058321
Views:
35
>>>>I want the count of the table to return empty even if it has
>>>>records mark as deleted. reccount() ignores set dele on.
>>>>any ideas?
>>>
>>>How about COUNT FOR NOT DELETED() TO lnRecCount?
>>
>>COUNT will move the cursor to the end of the table.
>>If you don't want he cursor to move, you could use also:
>>
>>SELECT Count(*) FROM MyTable WHERE Deleted() = .F.
>
>Take note that SELECT will not work for tables on table-buffering mode.

True, but you can set buffering off, SELECT, then on again...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform