spCustomFormEntry_Delete

Parameters

Parameter	Parameter Type	Mode	Description
@EntryID	uniqueidentifier	IN

Definition

Copy


CREATE procedure [dbo].[spCustomFormEntry_Delete]
        @EntryID        uniqueidentifier
    as

        DECLARE @ERROR INT
        BEGIN TRANSACTION

        SET @ERROR = @@ERROR
        IF @ERROR <> 0 GOTO ERR_HANDLER

            delete from [dbo].[CustomFormEntry]
            where [EntryID] = @EntryID

        SET @ERROR = @@ERROR
        IF @ERROR <> 0 GOTO ERR_HANDLER

        ERR_HANDLER:
        IF @ERROR = 0
            COMMIT TRANSACTION  
        ELSE
            ROLLBACK TRANSACTION   
        RETURN @ERROR