Subject | calc fields |
---|---|
Author | Scronkey |
Post date | 2002-07-24T03:02:37Z |
Hi there,
I have a master/detail relationship on a form.
The master has 4 calc fields, 2 of which are summed from the
relevant detail records. (SUM(Hours) & SUM(Cost)).
What is the most efficient way to cal these fields?
CalculateAllFields=True
I am currently opening a TIB_Cursor, and summing the relvant fields
to get my totals.
Is it inefficient to open a Cursor every time calc fields is called?
Or is there a way I can use the actual detail query used on the
form, as it is already limited to the values I need to sum?
Rgds,
-Ryan
I have a master/detail relationship on a form.
The master has 4 calc fields, 2 of which are summed from the
relevant detail records. (SUM(Hours) & SUM(Cost)).
What is the most efficient way to cal these fields?
CalculateAllFields=True
I am currently opening a TIB_Cursor, and summing the relvant fields
to get my totals.
Is it inefficient to open a Cursor every time calc fields is called?
Or is there a way I can use the actual detail query used on the
form, as it is already limited to the values I need to sum?
Rgds,
-Ryan