Subject Re: [firebird-support] Recursive Selectable Stored Procedure
Author Friedrich Remmert
Hi,

without knowing or understanding the details: the result set from
> for select ReportInto, SellingCode, SellNames, SellSurname
> from M_SELLINGENTITY
> where REPORTINTO = :TOPLEVEL
> into :REPORTINTO, :SELLINGCODE, :SELLNAME, :SELLSURNAME do
> begin
should be unique with respect to sellingcode (or grouped by sellingcode).

Without this assumption, I would expect surprising results (multiple listings
of the same record, infinite loop, ... ?).

fr.