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
07/11/1997 15:08:05
 
 
À
07/11/1997 13:53:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00058136
Message ID:
00058978
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform