| Subject | RE: [IBO] Re: Speed difference between TIBQuery and TIB_Query? |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-05-24T10:24:14Z |
At 11:41 AM 24/05/2004 +0200, you wrote:
were looking at a utility routine whose only purpose was to loop through a
buffered dataset and accrue a total. That can be avoided by pulling the
total over as a singleton returned into a TIB_DSQL using a GROUP BY query.
Helen
>Hi Helen,No, in this context we weren't talking about an interactive application, we
>
>Can you please explain "- don't forget about GROUP BY for getting totals."
>Up until now I've been running a separate dataset to display totals, are you
>implying there's an easier way ?
were looking at a utility routine whose only purpose was to loop through a
buffered dataset and accrue a total. That can be avoided by pulling the
total over as a singleton returned into a TIB_DSQL using a GROUP BY query.
Helen