Try putting AS xField.

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

----- Original Message -----
From: <kamen_lai@...>
To: <IBObjects@yahoogroups.com>
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