Hi

I notice in an awful lot of the store procedures examples there is a a SUSPEND statement towards the end.
I am using several stored procedures in my application but I do not use the SUSPEND statement.

Is this a problem / bad practice, I've not met any problems so far but I am a little concerned I may have a problem later.

Rgds

Peter


eg. a simple example

SET TERM ^^ ;
CREATE PROCEDURE P_FIND_UNSOLD_VOUCHER returns (VOUCHER_ID Integer, ID Integer)
AS
/*
Procedure: P_FIND_UNSOLD_VOUCHER

Author : PJC
Date : 15/sept/2003
Purpose : to find an unsold voucher for voucher return function
Params none, only uses Status = 0 , which is available
------
<param> : <purpose>
*/
begin
/* code */
SELECT First 1 VOUCHER_ID,ID from PINS where STATUS = 0
INTO :VOUCHER_ID,:ID ;
end
^^
SET TERM ; ^^

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