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
08/11/1997 00:06:48
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
 
 
To
07/11/1997 15:08:05
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00058136
Message ID:
00059045
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

USE TABLE AGAIN doesn't include buffer records. That is my understanding. The way I do it is to use COPY TO to get the buffer records in. I think I saw this method used in one of the articles in Foxpro Advisor.
Previous
Reply
Map
View

Click here to load this message in the networking platform