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,
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.
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
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):
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