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

2018-04-13 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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, >        '00' as MEIO_PAGAMENTO, >        N.VLRTOTALNOTA as VALOR, >        0 as AUTENT_01, >        0

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