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

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

 Error: 
 can't format message 13:587 -- message file D:\GDS_FBCLIENT\FB3\firebird.msg 
not found.
 conversion error from string "DINHEIRO".
 

 Of course, the index for the field "const" does not make much sense, the 
strange is the error.

 

 because the constant field will be the same value in all registers.

 

 Firebird: Server version: WI-V6.3.3.32900 Firebird 3.0