At 12:51 PM 06-08-01 +0200, you wrote:

>I have a query which fetches 65 rows when executed through IB_SQL. However,
>if I click the sigma sign to count the number of rows the result is 88!
>After inspection, I suspect the reason to be because I have DISTINCT in my
>query. Removing the DISTINCT I do indeed get 88 rows. I thought about
>including my SQL in this mail, but the result is 100% reproducable using
>any query.
>
>Is it intended behaviour that the "sigma count" does not care about
>DISTINCT, and if so why?

Svein,
I believe this sigma button delivers RowsAffected, not RecordCount. I would expect to see the whole count of the table rows contributing to your output set.

Regards,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________