Subject Re: RES: [firebird-support] Table/field Alias -> relname in SQLDA
Author Mark Rotteveel
On Fri, 23 May 2014 01:48:31 -0300, "Antônio Cristóvão Gomes
acgomes2001@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
> then why not include "Alias ​​Table" in "XSQLVAR"?

The information for the relation alias has only been available since
Firebird 2.0. There is no field for it in an XSQLVAR, and extending it has
several issues with backwards compatibility. Also in my experience,
information on the table alias is rarely if ever needed. For those
exceptional cases you do need it, you can retrieve it with
isc_dsql_sql_info.

> this function should be used to retrieve the table alias?
>
> function isc_dsql_sql_info(user_status: PISCStatus; stmt_handle:
> PIscStmtHandle;
>
> item_length: Smallint; items: PISCSChar; buffer_length: Smallint;
> buffer: PISCSChar):
>
> ISCStatus;

Yes.

Mark