You must use FetchAll to get all records from the server.

Artur

----- Original Message -----
From: hugosan@...
To: IBObjects@yahoogroups.com
Sent: Monday, September 17, 2001 7:22 PM
Subject: [IBO] Calculated field to get SUM(SOME_FLOAT_FIELD)


I have a Master-Detail relation, with an Order-Header and multiple
Order-Item. The user makes the inserts in a Detail-Grid, and I use
an Order-Item.CalculatedField to maintain and show the total amount
by accumulating a global variable at OnCalcFields event.
The problem is when there are more rows than the Grid can show: the
other rows fire the OnCalcFields event only if the user requests them,
and my total_amount is not real unlike the user scrolls all the grid
up and down...
Is there any way to force the Calculate for all the Dataset?
Any other approach? I could make a Query for only SELECT SUM(..) FROM
DETAIL, but I think that's too much traffic with the server.
Thanks in advance,
Hugo.



Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]