Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Counting records in a grid?
Message
De
16/08/2001 10:38:09
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
16/08/2001 10:34:02
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00541182
Message ID:
00544686
Vues:
12
>>Hi Cetin,
>>
>>I solved my problem with record count in grids -simply by using COUNT TO myVar FOR etc...
>>
>>I just forgot that I had already tried RECCOUNT(), which always counts the whole file, while COUNT allows for expressions..
>>
>>Rolf
>
>Rolf,
>Yes :)
>If buffering is not an issue select approach doesn't move the pointer.
>Cetin

BTW if you'd use count sometimes you could speed it up :

select child
seek(master.id,'child','childfk')
count while child.childfk=master.id to nVar

* or if you need extra expression
count while child.childfk=master.id for ExtraCriteria to nVar

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform