Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to count records in a child table ?
Message
From
09/03/2004 17:14:53
 
 
To
09/03/2004 17:00:11
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00884570
Message ID:
00884595
Views:
11
>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!

Nice !
Thanks (again) Erick !

Steph
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform