USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSPOUSEUPDATEPAGEDATA

The load procedure used by the view dataform template "Constituent Spouse Update Page Expression 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.
@CONSTITID	uniqueidentifier	INOUT	CONSTITID
@NAME	nvarchar(400)	INOUT	NAME
@SPOUSEID	uniqueidentifier	INOUT	SPOUSEID
@SPOUSENAME	nvarchar(400)	INOUT	SPOUSENAME
@MAPPINGCREDENTIALSEXIST	bit	INOUT	MAPPINGCREDENTIALSEXIST

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSPOUSEUPDATEPAGEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CONSTITID uniqueidentifier = null output,
                    @NAME nvarchar(400) = null output,
                    @SPOUSEID uniqueidentifier = null output,
                    @SPOUSENAME nvarchar(400) = null output,
                    @MAPPINGCREDENTIALSEXIST bit = null output
                )
                as
                set nocount on;
                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @CONSTITID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID,
                    @NAME = CONSTIT.NAME,
                    @SPOUSEID = RELATIONSHIP.RECIPROCALCONSTITUENTID,
                    @SPOUSENAME = SPOUSE.NAME
                from
                    dbo.RELATIONSHIP
                inner join
                    dbo.CONSTITUENT CONSTIT
                on
                    CONSTIT.ID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID
                inner join
                    dbo.CONSTITUENT SPOUSE
                on
                    SPOUSE.ID = RELATIONSHIP.RECIPROCALCONSTITUENTID
                where
                    RELATIONSHIP.ID = @ID

                declare @MAPPINGCREDENTIALSID uniqueidentifier;
                select top 1
                    @MAPPINGCREDENTIALSID = ID
                from
                    dbo.MAPPINGCREDENTIALS
                where
                    len([KEY]) > 0;

                if @MAPPINGCREDENTIALSID is not null
                    set @MAPPINGCREDENTIALSEXIST = 1;
                else
                    set @MAPPINGCREDENTIALSEXIST = 0;

                return 0;