Subject | Re: RES: [firebird-support] Table/field Alias -> relname in SQLDA |
---|---|
Author | Mark Rotteveel |
Post date | 2014-05-23T07:21:40Z |
On Fri, 23 May 2014 01:48:31 -0300, "Antônio Cristóvão Gomes
acgomes2001@... [firebird-support]"
<firebird-support@yahoogroups.com> wrote:
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.
Mark
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?Yes.
>
> function isc_dsql_sql_info(user_status: PISCStatus; stmt_handle:
> PIscStmtHandle;
>
> item_length: Smallint; items: PISCSChar; buffer_length: Smallint;
> buffer: PISCSChar):
>
> ISCStatus;
Mark