USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITSPOUSEDATA

The load procedure used by the view dataform template "NetCommunity Constituent Spouse Data 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.
@TITLE	nvarchar(100)	INOUT	TITLE
@FIRSTNAME	nvarchar(50)	INOUT	FIRSTNAME
@MIDDLENAME	nvarchar(50)	INOUT	MIDDLENAME
@KEYNAME	nvarchar(100)	INOUT	KEYNAME
@MAIDENNAME	nvarchar(100)	INOUT	MAIDENNAME
@SUFFIX	nvarchar(100)	INOUT	SUFFIX
@FULLNAME	nvarchar(154)	INOUT	FULLNAME
@CLASSOF	smallint	INOUT	CLASSOF
@TITLE2	nvarchar(100)	INOUT	TITLE2
@SUFFIX2	nvarchar(100)	INOUT	SUFFIX2

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCCONSTITSPOUSEDATA
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TITLE nvarchar(100) = null output,
                    @FIRSTNAME nvarchar(50) = null output,
                    @MIDDLENAME nvarchar(50) = null output,
                    @KEYNAME nvarchar(100) = null output,
                    @MAIDENNAME nvarchar(100) = null output,
                    @SUFFIX nvarchar(100) = null output,
                    @FULLNAME nvarchar(154) = null output,
                    @CLASSOF smallint = null output,
                    @TITLE2 nvarchar(100) = null output,
                    @SUFFIX2 nvarchar(100) = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    declare @BBNCID int;
                    select
                        @BBNCID = [SEQUENCEID],
                        @DATALOADED = 1, -- TMV 03/29/2007 CR268638-030107 The constituent record exists whether or it has spouse data
                        -- Since there may not be a spouse row, set the other output parameters to null just incase someone sent up values in the parameters
                        @TITLE = null,
                        @TITLE2 = null,
                        @FIRSTNAME = null,
                        @MIDDLENAME = null,
                        @KEYNAME = null,
                        @MAIDENNAME = null,
                        @SUFFIX = null,
                        @SUFFIX2 = null,
                        @FULLNAME = null,
                        @CLASSOF = null
                    from
                        dbo.CONSTITUENT
                    where
                        [ID] = @ID;

                    declare @T table(TITLE nvarchar(100), 
                                     TITLE2 nvarchar(100), 
                                     FIRSTNAME nvarchar(50),
                                     MIDDLENAME nvarchar(50),
                                     KEYNAME nvarchar(100),
                                     MAIDENNAME nvarchar(100),
                                     SUFFIX nvarchar(100),
                                     SUFFIX2 nvarchar(100),
                                     FULLNAME nvarchar(154),
                                     CLASSOF smallint,
                   SPOUSEID uniqueidentifier,
                   RELATIONSHIPCODEID uniqueidentifier,
                   RECIPROCALCODEID uniqueidentifier,
                   GENDERCODE int
                                     );
                    insert into @T 
                    (
                        TITLE, 
                        TITLE2, 
                        FIRSTNAME,
                        MIDDLENAME,
                        KEYNAME,
                        MAIDENNAME,
                        SUFFIX,
                        SUFFIX2,
                        FULLNAME,
                        CLASSOF,
            SPOUSEID,
            RELATIONSHIPCODEID,
            RECIPROCALCODEID,
            GENDERCODE
                    )
                    exec dbo.USP_BBNC_CONSTITSPOUSEDATA @BBNCID;

                    select top 1 
                        @TITLE = [TITLE],
                        @TITLE2 = [TITLE2],
                        @FIRSTNAME = [FIRSTNAME],
                        @MIDDLENAME = [MIDDLENAME],
                        @KEYNAME = [KEYNAME],
                        @MAIDENNAME = [MAIDENNAME],
                        @SUFFIX = [SUFFIX],
                        @SUFFIX2 = [SUFFIX2],
                        @FULLNAME = [FULLNAME],
                        @CLASSOF = [CLASSOF]
                    from @T;

                    return 0;