"Nic Wise" <[EMAIL PROTECTED]> wrote on 30/05/2001 09:46:33:
>
>> > CREATE PROCEDURE PRO_GETSLPRTY
>> > RETURNS (ID_SLPRTY INTEGER)
>> > AS
>> > BEGIN
>> > ID_SLPRTY = gen_id(GEN_SLPRTY, 1);
>
>um, dont you need a
>
>SUSPEND;
>
>right about here? Or is that just for ones you execute with
>
>select * from PRO_GETSLPRTY
SUSPEND is for stored procs that return multiple records. Basically
it's an "I'm done with this record, you can have it now" type thing.
Once the database engine is finished dealing with that record it
returns to the SP to get the next one.
In the case of SPs like this that return a single result SUSPEND is
kind of pointless.
--
Corey Murtagh
The Electric Monk
"Quidquid latine dictum sit, altum viditur!"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
