USP_DATAFORMTEMPLATE_EDITLOAD_GROUPMEMBER

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@MEMBERNAME	nvarchar(700)	INOUT	Member
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date
@COMMENTS	nvarchar(300)	INOUT	Comments
@GROUPMEMBERDATERANGEID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPMEMBER
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @MEMBERNAME nvarchar(700) = null output,
  @STARTDATE date = null output,
  @ENDDATE date = null output,
  @COMMENTS nvarchar(300) = null output,
  @GROUPMEMBERDATERANGEID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = GROUPMEMBERDATERANGE.TSLONG,
    @MEMBERNAME = MEMBER_NF.NAME,
    @STARTDATE = GROUPMEMBERDATERANGE.DATEFROM,
    @ENDDATE = GROUPMEMBERDATERANGE.DATETO,
    @COMMENTS = GROUPMEMBERDATERANGE.COMMENTS,
    @GROUPMEMBERDATERANGEID = GROUPMEMBERDATERANGE.ID
  from
    dbo.GROUPMEMBER
  outer apply
    dbo.UFN_CONSTITUENT_DISPLAYNAME(GROUPMEMBER.MEMBERID) MEMBER_NF
  inner join
    dbo.GROUPMEMBERDATERANGE on GROUPMEMBERDATERANGE.GROUPMEMBERID = GROUPMEMBER.ID
  where
    GROUPMEMBER.ID = @ID

  return 0;