[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,

[firebird-support] order by 1, 2 - fb 32990

2018-04-12 Thread acgomes2...@yahoo.com.br [firebird-support]
hi: select A.Codigo 'DINHEIRO' FORMA_PAGTO FROM NF A where A.dataEmissao between '01.01.2018' and '31.01.2018' and A.Modelo = '55' order by 1, 2 using, "order by 2", return a error but, if i use: cast('DINHEIRO' as varchar(10)) FORMA_PAGTO does not ocorrur.

Re: [firebird-support] order by 1, 2 - fb 32990

2018-04-13 Thread acgomes2...@yahoo.com.br [firebird-support]
hi helen... the comma is the less problem... A correct sql: select N.DTEMISSAONOTA as DATA, 'DINHEIRO' as MEIO_PAGAMENTO1, cast('DINHEIRO' as char(10)) as MEIO_PAGAMENTO2, '00' as MEIO_PAGAMENTO, N.VLRTOTALNOTA as VALOR, 0 as AUTENT_01, 0

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]
then why not include Alias ​​Table in XSQLVAR? 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):

Re: [firebird-support] UDF or/and maybe Charset problem

2017-08-24 Thread Antônio Gomes acgomes2...@yahoo.com.br [firebird-support]
there no a null string? De: "Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]" Para: Firebird-support Enviadas: Quinta-feira, 24 de Agosto de 2017 6:41 Assunto: [firebird-support] UDF or/and maybe