USP_EVENTCONFLICT_DELETE

Executes the "Event Conflict Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                    CREATE procedure dbo.USP_EVENTCONFLICT_DELETE
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier
                        )
                    as
                        set nocount on;

                        begin

                            declare @e int;
                            declare @contextCache varbinary(128);

                            /* cache current context information */
                            set @contextCache = CONTEXT_INFO();

                            /* set CONTEXT_INFO to @CHANGEAGENTID */
                            if not @CHANGEAGENTID is null
                                set CONTEXT_INFO @CHANGEAGENTID

                            delete from PROGRAMEVENTLOCATION where EVENTCONFLICTID=@ID;
                            delete from EVENTRESOURCE where EVENTCONFLICTID=@ID;
                            delete from EVENTSTAFFRESOURCE where EVENTCONFLICTID=@ID;

                            /* reset CONTEXT_INFO to previous value */
                            if not @contextCache is null
                                set CONTEXT_INFO @contextCache

                            select @e=@@error;

                            if @e<>0 return -456; --always return non-zero sp result if an error occurs              


                            --now delete the eventconflict row

                            exec USP_EVENTCONFLICT_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
                        end

                        return 0;