At 10:35 AM 14-08-01 -0600, you wrote:

>Thanks, those are great clues. One question though, I thought you needed to
>use suspend even if you wanted to only return one row.
>Not true??

No: the purpose of SUSPEND is to hold the output back and wait for another row, so you place it at the end of a FOR SELECT...DO... loop.

'night

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________