>
> I've had people in here tell me that using a stored procedure that selects
> records without a "suspend" command at the end will not return records or

is

> incorrect syntax. I'm not saying you're all wrong but I just came across

an

> example in my application where this is obviously proving that axiom to be
> incorrect.

Your procedure only returns one record so it acts more like a "function".
Whenever you are only returning one set of values, it is not necessary to
use SUSPEND. It is only needed when looping through to return more than one
set of data. However, and someone can correct me if I'm wrong, if by chance
the select ever results in more than one record, it will error.

Woody (TMW)