USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER_2

The save procedure used by the edit dataform template "GroupMember Edit Data Form".

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.
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@COMMENTS	nvarchar(300)	IN	Comments

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @STARTDATE date,
  @ENDDATE date,
  @COMMENTS nvarchar(300)
)
as
    set nocount on;

    declare @GROUPMEMBERDATERANGEID uniqueidentifier

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPMEMBER
        @ID = @ID,
        @GROUPMEMBERDATERANGEID = @GROUPMEMBERDATERANGEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER_3
        @ID,
        @CHANGEAGENTID,
        @STARTDATE,
        @ENDDATE,
        @COMMENTS,
        @GROUPMEMBERDATERANGEID

    return 0;