Subject Re: [firebird-support] MULTIPLE ROWS IN SINGLETON SELECT in SP
Author Lucas Franzen

Tanz Anthrox schrieb:

> Thank you LUCAS and EDUARDO,
> If I do not place a SUSPEND command before IF statement, the result is
> wrong...
> Does SUSPEND means FETCH to Next record?

No, suspend means: "write the record to the output stream".

If you don't put a suspend before your IF statement the output might be
wrong because the records which haven't got an existing child record
won't be written to the output stream.

The fetch is done with the FOR SELECT ... loop.