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
From
07/11/1997 15:08:05
 
 
To
07/11/1997 13:53:32
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00058136
Message ID:
00058978
Views:
41
>>>>>This thread is nice example what buffering used once may involve later. I guess now, it would be good idea to open table in another area USE...AGAIN and COUNT there. New records in buffer can be counted separately (if necessary) for negative RECNO().
>>>>
>>>>Ed, I haven't checked this, but if you USE...AGAIN will it include records in the buffer of the original USE... ?
>>>>
>>>>Barbara
>>>
>>>I've never tried that dreadful situation, but I saw that Dave Johns advised this idea for buffered tables, so I believe he tried.
>>
>>
>>Instead of doing any extra work, why not just keep a counter
>>of the records. Start with reccount() prior to data entry and
>>then use add or subtract to this counter while still in
>>buffered mode to keep track of the number of records.
>>
>>Dan
>
>This thread is too deep to be practical, but just think how your suggestion would work in multi-user environment.

I don't think you are ever going to get an accurate picture while
others using buffering are adding and deleting records. The best
you can do is to as you suggested before, USE TABLE AGAIN
and use RECCOUNT() right before determining the number of records.
Then use your internal count to add to this RECCOUNT().

Dan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform