Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to count records in a child table ?
Message
De
09/03/2004 17:00:11
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
 
 
À
09/03/2004 16:16:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00884570
Message ID:
00884592
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
Hi Steph!

>Hello,
>I have 2 free tables. I establish a relation between them.
>But how to count records in the child table (result of the relation) ?
>Thanks a lot !
>Steph

Try the Count command and in the For clausula put the condition of the relation, thus:
Select tableChild
count for tableChild.myCod = tableParent.myCod to lnCountChild
I hope this help you!
Good Luck!
Erick
Força Sempre!
Strength Always!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform