USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTINACTIVEDETAIL

The load procedure used by the view dataform template "Constituent Inactive Detail View 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.
@CONSTITUENTINACTIVITYREASON	nvarchar(63)	INOUT	Reason
@DETAILS	nvarchar(300)	INOUT	Details

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTINACTIVEDETAIL
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CONSTITUENTINACTIVITYREASON nvarchar(63) = null output,
                    @DETAILS nvarchar(300) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @DATALOADED = 1,
                           @CONSTITUENTINACTIVITYREASON = dbo.UFN_CONSTITUENTINACTIVITYREASONCODE_TRANSLATE(CONSTITUENTINACTIVEDETAIL.CONSTITUENTINACTIVITYREASONCODEID),
                           @DETAILS = CONSTITUENTINACTIVEDETAIL.DETAILS
                    from dbo.CONSTITUENT
                    left join dbo.CONSTITUENTINACTIVEDETAIL on CONSTITUENT.ID = CONSTITUENTINACTIVEDETAIL.ID
                    where CONSTITUENT.ID = @ID

                    return 0;