Re: RES: [firebird-support] Table/field Alias - relname in SQLDA

2014-05-23 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Fri, 23 May 2014 01:48:31 -0300, Antônio Cristóvão Gomes acgomes2...@yahoo.com.br [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

[firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread acgomes2...@yahoo.com.br [firebird-support]
I have the SQL: select CADPRO.CLIENTE_PRO, CADPRO.FORNECEDOR_PRO, CADGRU.NOME_GRU, SUBGRUPO.NOME_SUBGRU, COLECAO.NOME_COL, MARCA.DESCRICAO_MARCA, NCM.NCM_NCM, NCM.EX_NCM, NCM.DESCRICAO_NCM,

Re: [firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-5-2014 19:15, acgomes2...@yahoo.com.br [firebird-support] wrote: I have the SQL: select CADPRO.CLIENTE_PRO, CADPRO.FORNECEDOR_PRO, ... FORNECEDOR.NOME_CLI NOME_FORNECEDOR, CLIENTE.NOME_CLINOME_CLIENTE, .. from CADPRO inner join CADCLI as FORNECEDOR on

RES: [firebird-support] Table/field Alias - relname in SQLDA

2014-05-22 Thread Antônio Cristóvão Gomes acgomes2...@yahoo.com.br [firebird-support]
: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Table/field Alias - relname in SQLDA On 22-5-2014 19:15, acgomes2...@yahoo.com.br mailto:acgomes2...@yahoo.com.br [firebird-support] wrote: I have the SQL: select CADPRO.CLIENTE_PRO, CADPRO.FORNECEDOR_PRO