--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...>
wrote:

> Muthu,
>
>
> [Big snip]
>
> > UPDATE DENOMINATION SET BILLCOUNT = :HUNDRED, FLAG=:FLAG
> > WHERE BILLTYPE = 'OBHUNDRED';
> > SUSPEND;
> > END
>
> [another snip]
>
> >
> > EXECUTE PROCEDURE GETDENOMINATIONTOTAL
> > RETURNING_VALUES
> > (:OPENINGBALANCE,:CASHIN,:CASHOUT,:CLOSINGBALANCE);
>
> You must not execute a procedure that's a selectable one (working

with

> SUSPEND).
> If this is the case you have to SELECT from that procedure.
>
> SELECT * [OR OUTPUTFIELDS] FROM GETDENOMINATIONTOTAL
> INTO :OPENINGBALANCE,:CASHIN,:CASHOUT,:CLOSINGBALANCE;
>
> is the way to go.
>
> Luc.

Thanks Luc,it worked.

firebird group is lucky to have people like Luc.

Keep up your work.

Muthu