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]