13.04.2018 13:30, acgomes2...@yahoo.com.br wrote:
>
> select N.DTEMISSAONOTA as DATA,
> 'DINHEIRO' as MEIO_PAGAMENTO1,
> cast('DINHEIRO' as char(10)) as MEIO_PAGAMENTO2,
> '000000' as MEIO_PAGAMENTO,
> N.VLRTOTALNOTA as VALOR,
> 0 as AUTENT_01,
> 0 as AUTENT_01_CALC,
> N.AUTENTICACAO_NOTA as AUTENT_02,
> 3 as TIPO
> from NOTA N
> where (N.EMPRESANOTA = 1)
> and (N.DTEMISSAONOTA between '05/11/2018' and '04/11/2018')
> and (N.MODELONOTA = '55')
> order by 1, 2
http://tracker.firebirdsql.org/browse/CORE-5743
Dmitry
