drosenkranz
Programmer
Hello,
I have an app where the main table's records have a unique ID. There are several other (child) tables which may have one or more related records. I'm using VFP 7 with the database container and .cdx's (no free tables). I have not created any persistent relationships.
Sometimes I need to count the number of related records in another table(s), other times I need a total for a specific field (dollar amount) in the related records. Often times - both of these will be true - and there could be as many as four different (child) tables being processed. I'm running the EXE's on each local user's machine and the data is stored up on a Win 2k server. As a "general rule of thumb", which is the better choice performance wise:
1) setting and unsetting filters in the related table(s).
2) SQL-Select records from the related table(s) to a cursor.
3) Locate and then Count For "somevalue" while "somecondition" remains true.
Thanks for your time,
Dave
The 2nd mouse gets the cheese.
I have an app where the main table's records have a unique ID. There are several other (child) tables which may have one or more related records. I'm using VFP 7 with the database container and .cdx's (no free tables). I have not created any persistent relationships.
Sometimes I need to count the number of related records in another table(s), other times I need a total for a specific field (dollar amount) in the related records. Often times - both of these will be true - and there could be as many as four different (child) tables being processed. I'm running the EXE's on each local user's machine and the data is stored up on a Win 2k server. As a "general rule of thumb", which is the better choice performance wise:
1) setting and unsetting filters in the related table(s).
2) SQL-Select records from the related table(s) to a cursor.
3) Locate and then Count For "somevalue" while "somecondition" remains true.
Thanks for your time,
Dave
The 2nd mouse gets the cheese.