Previously it would just give you the wrong count!
I'll add this to the list of bugs to fix.

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

----- Original Message -----
From: <kamen_lai@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, August 24, 2001 11:43 PM
Subject: Re: [IBO] RecordCount Error


> this error only occur tib_cursor Component, you can make a simple
> test in IB_SQL , Cursor Tab
> Enter
>
> 'Select Distinct Field1 xField from Sc_det'
> or
> 'Select Distinct Field1 as xField from Sc_det'
>
> the return result are correct but when i click then
> 'Count Rows in Dataset' Button
> error will occur.
>
>
> This error seens occur in IB_Parse.pas ,
> procedure MakeCountSQL
> which only determine ',' exists but did'nt take care about alias
> fieldname no matter 'as' exist or not.
>
>