USP_DATAFORMTEMPLATE_EDIT_EVENTTASK

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@OWNERID	uniqueidentifier	IN	Owner
@NAME	nvarchar(100)	IN	Task
@COMPLETEBYDATE	datetime	IN	Date due
@STATUSCODE	tinyint	IN	Status
@DATECOMPLETED	datetime	IN	Date completed
@COMMENT	nvarchar(250)	IN	Comment

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTTASK
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @OWNERID uniqueidentifier,
    @NAME nvarchar(100),
    @COMPLETEBYDATE datetime,
    @STATUSCODE tinyint,
    @DATECOMPLETED datetime,
    @COMMENT nvarchar(250)
)
as
    set nocount on;

    declare @REMINDERS xml;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTTASK
        @ID = @ID,
        @REMINDERS = @REMINDERS output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTTASK_2 @ID, @CHANGEAGENTID, @OWNERID, @NAME, 
        @COMPLETEBYDATE, @STATUSCODE, @DATECOMPLETED, @COMMENT, @REMINDERS;

    return 0;