Re: [firebase-br] SQL funciona na versão 1.5 e não na 2.0

[Magno System]

Tente assim:

select coalesce(trelsld.qtdsaldo,0) qtdsaldo,
coalesce(trelsld.totalsaldo,0) totalsaldo

   from trelsld

   where trelsld.idprd = :idprd and

         trelsld.filial = :filial and

         trelsld.saldo = :saldo and

         trelsld.codloc = :codloc and

         trelsld.sequencialsaldo = (select max(trelsld.sequencialsaldo)

                                       from trelsld ultimo

                                       where ultimo.idprd = :idprd and

                                             ultimo.saldo = :saldo and

                                             ultimo.filial = :filial and

                                             ultimo.codloc = :codloc)