USP_DATAFORMTEMPLATE_ADD_DONORCHALLENGENOTE_PRELOAD

The load procedure used by the edit dataform template "Donor Challenge 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
@DONORCHALLENGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy



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

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

                      return 0;