On Tue, 16 Dec 2014 11:03:39 +0200, Vlad Khorsun <hv...@users.sf.net> wrote: > 16.12.2014 10:27, Rudolf Grauberger wrote: >> I would like to read the table aliases, > > After call of isc_dsql_prepare() you'll have XSQLDA structure filled > with all > info, including known relation aliases. Read IB6 "API Guide", chapter > "Working > with Dynamic SQL". Guide is available here: > > http://www.firebirdsql.org/en/reference-manuals/
The XSQLDA doesn't include the relation alias, only the relation name (and the column name and alias). So you need to to use sql_info to obtain the relation_alias; isc_info_sql_relation_alias was also only added in Firebird 2. >> here I found out that I need to call the >> function isc_dsql_sql_info () with the parameter >> isc_info_sql_relation_alias. > > Usually you don't need to do it yourself as client library did all the > work > behind the scene when you do prepare\execute the SQL statement. Except if you need more information than Firebird provides by default. Mark ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
