USP_DATAFORMTEMPLATE_ADD_CONSTITUENTRECOGNITIONHISTORY_PRELOAD

The load procedure used by the edit dataform template "Constituent Recognition History Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECOGNITIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RECOGNITIONPROGRAMID	uniqueidentifier	INOUT	Recognition program

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTRECOGNITIONHISTORY_PRELOAD
                (
                @CONSTITUENTRECOGNITIONID uniqueidentifier,
                @RECOGNITIONPROGRAMID uniqueidentifier = null output
                )
                as
                set nocount on;

                select @RECOGNITIONPROGRAMID = CR.RECOGNITIONPROGRAMID
                from dbo.CONSTITUENTRECOGNITION CR
                where CR.ID = @CONSTITUENTRECOGNITIONID

                return 0