I was able to track down the issue and discovered that it was related to the StripDoubleQuotesFromFieldNames flag in the TIBODataSet file.

Setting the flag to True solved the problem.

Sorry for the inconvenience.

Thanks,
Leo Euclides

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
>
> More information is needed to see what is going one.
> What is the DDL of the table and what is the actual Query SQL?
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of rosana@...
> Sent: 12 November 2012 09:54 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Alias issue - IBO 4.9.14
>
> Hello,
>
> I'm having an issue with alias when using IBO 4.9.14 Build 53 on Delphi 6
> with Firebird 2.5.2.26539.
>
> When i try to use " FieldByName('Client').AsString " in a IBOQuery with the
> SQL 'Select CLIENT_NAME as "Client" From Clients', i get the error " Field
> 'Client' doesn't exist. ". If i try the alias with double quotes (
> FieldByName('"Client"') ) it works just fine.
>
> Until updating IBO from 4.9.10 to 4.9.14 the alias didn't have double
> quotes.
>
> Anyone had the same problem?
>
> Thanks,
> Leo Euclides
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>