Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I check for the number if recods in a table?
Message
De
08/11/1997 00:06:48
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapour
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00058136
Message ID:
00059045
Vues:
46
>>>>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform