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.

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Try putting AS xField.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <kamen_lai@y...>
> To: <IBObjects@y...>
> Sent: Friday, August 24, 2001 12:29 AM
> Subject: [IBO] RecordCount Error
>
>
> > IBO v4.2Eb
> > D5 Ent
> >
> > Select Distinct Field1 xField from Sc_det
> >
> >
> > when call RecordCount , Error Occur
> >
> > ISC ERROR CODE:335544569
> >
> > ISC ERROR MESSAGE:
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 1, char 37
> > xField