Noted. Not on a high priority to fix however.

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

----- Original Message -----
From: "achidan" <ac.hi@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, April 09, 2002 11:16 PM
Subject: [IBO] RecordCount, Distinct and as-Fields


> Hi Jason
>
> I found another problem with RecordCount for a statement like this:
>
> SELECT DISTINCT Fld1, Fld2 as Fld3 FROM Table1
>
> This is transformed for the RecordCount statement as
>
> SELECT COUNT(DISTINCT Fld1 || '.zZz.' || Fld2 as Fld3) FROM Table1
>
> which is not working.
>
> Cheers
> Daniel
>