> Thanks,
>
> On Monday 30 September 2002 19:17, Woody wrote:
> > I don't believe a SUSPEND statement is needed here. This procedure isn't
> > returning a recordset, it's only inserting new records. The return value
> > can still be obtained without using SUSPEND.
>
> How should we obtain the value? If we ask the geenrator after calling the
> procedure, we risk to read the wrong value, or am I wrong?

How are you executing the procedure? Using SELECT or EXECUTE? In Delphi, I
use a stored procedure component to execute the procedure and return the
value.



Woody (TMW)

----------------------
"To invent, you need a good imagination and a pile of junk."
Thomas Edison