Thanks so much Helen - greatly appreciated.
One question: I need to remove the suspend; from the SP? I thought I needed
this whenever returning a value. Apparently just for a record set?
Kevin

[snip]

>//~~~~~~~~~~~~~~~~~~~~~~
>sp_get_nextid looks like this:
>CREATE PROCEDURE SP_GET_NEXTID(
> IDTYPE VARCHAR(15))
>RETURNS (
> NEXTID INTEGER)
>AS
>BEGIN
> if (IDType = 'QUOTE') then
> NextID = GEN_ID(GEN_QUOTES, 1);
>
> if (IDType = 'ORDERNO') then
> NextID = GEN_ID(GEN_ORDERNO, 1);
>
>/* many more of these */

>Suspend; <----------NO!!! <----------because you want to EXECUTE this
>end
>//~~~~~~~~~~~~~~~~~~~~~~
> [snip]

[Non-text portions of this message have been removed]