Subject Re[2]: [ib-support] Select Count(*) strange Result
Author Svein Erling Tysvaer
have you tried setting RecordCountAccurate or read the RowsSelected
property? I don't know if this will give you what you want, but it's a
place to start.


At 21:16 17.12.2002 +0100, you wrote:
> > Count(*) returns the number of rows that are "grouped". In your case the
> > number of distinct rows from WBG.VERKAUFSKONTO and A.UMSATZSTEUERCODE. Add
> > to Count(*) to your first query and you'll see.
>thank you, of course that is right. It was not my idea but the
>strategy behind IBObjects Recordcount method for this query. I was
>analyzing it because of the unexpected result.
>But how can I determine the number of record after grouping? Fetching
>all in a while loop? As I often recognize, SQL is so easy in the books
>but not so easy, when solving real worlds queries. ;-)