[firebase-br] ajuda com stored procedure

[samuel ferreira]

ola

acho q vc ta kerendo algo +- assim:

create or alter procedure  comissao
(
  vlrcom_prod numeric(10,2),
  vlrcom_geral_recebido numeric(10,2),
  pini varchar(100),
  pfim varchar(100),
  vini integer,
  vfim integer
)
returns
(
  total numeric(10,2)
)
as
begin
 select coalesce(sum(d.vlrunitario*p.comissao/100),0) as vlrcom_prod
  from d_venda d
     inner join produto p
   on d.codpro = p.codigo
  inner join caixa cx
   on d.codvenda = cx.fat_num
  inner join c_venda v
   on d.codvenda = v.codigo
  where p.codsgrupo = 1 and
         cx.data between :pini and :pfim and
        v.codfunc between :vini and :vfim
  into :vlrcom_prod;


 select coalesce(sum(cx.valor*p.comissao/100),0) as vlrcom_geral_recebido
  from d_venda d
  inner join produto p
   on d.codpro = p.codigo
  inner join caixa cx
   on d.codvenda = cx.fat_num
  inner join c_venda v
   on d.codvenda = v.codigo
  where p.codsgrupo = 1 and
          cx.data between :pini and :pfim and
        v.codfunc between :vini and :vfim
  into :vlrcom_geral_recebido;

total = vlrcom_prod - vlrcom_geral_recebido;
suspend;
end