USP_DATAFORMTEMPLATE_ADD_MEMBERNOTE_PRELOAD

The load procedure used by the edit dataform template "Member Note Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@AUTHORID	uniqueidentifier	INOUT	Author
@MEMBERSHIPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MEMBERNOTE_PRELOAD
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @AUTHORID uniqueidentifier = null output,
                @MEMBERSHIPID uniqueidentifier
            )
            as
                set nocount on;

                select top 1
                    @AUTHORID = CONSTITUENTID
                from
                    dbo.APPUSER
                where
                    ID = @CURRENTAPPUSERID;                    

                return 0;