Thanks for the tips.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Nando Dessena" <nandod@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, August 09, 2001 9:58 AM
Subject: Re: [IBO] Strange behaviour of IB_SQL


> Jason,
>
> > It is not intended behavior. I think what it should do is impose a
fetchall
> > or raise an exception that it cannot determine the count.
>
> I assume you do a select count(*) to count the rows.
>
> If the query selects just one column (as is often the case with
> distinct), perhaps you could use
>
> select count (distinct fieldname) from table where ...
>
> Why SQL does not allow this syntax with more that one column, I ignore.
> Ciao
> --
> ____
> _/\/ando