Summarize Operation

[metadyne]

For fast execution I use the script generated from a summarise operation whose logic should work as follows:

Group by member no
Find last transaction date for that member
Write closing balance for that date
Filter Where period is less than X

But what happens is I get a summarised table containing member no and the closing balance of the highest record number cf last transaction date where the period is less than X

I can write conventional script (table.open, query.order, while .not. t.fetch_eof...) but such a script takes much longer to run than that from the operation.

How can I achieve the required result without taking a long time (7 mins vs 10 seconds for the operation)?

[Stan Mathews]

Re: Summarize Operation

The summarize operation does not so much "find" the record with the last transaction date as it "reports" the last transaction date in the summarization field. You could easily have several first, last, min, max, etc summarizations in a defined operation. The operation doesn't find a record that satisfies all the elements of the definition, it reports/stores the value that fits each individual summarization element.

When you try a conventional script are you taking advantage of LQO, using .batch_begin() and .batch_end()?

[metadyne]

Re: Summarize Operation

I was not using batch begin/end but will try.

I cannot use LQO as the filter on the transaction table is a combination of 2 fields - namely the member no and the invert of the transaction date.