USP_DATAFORMTEMPLATE_VIEW_OTHERMEMBERINFO

The load procedure used by the view dataform template "Other Member Info 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.
@LASTNAME	nvarchar(100)	INOUT	Last name
@FIRSTNAME	nvarchar(50)	INOUT	First name
@MIDDLENAME	nvarchar(50)	INOUT	Middle name
@BIRTHDATE	UDT_FUZZYDATE	INOUT	Birth date
@GENDERCODE	tinyint	INOUT	Gender
@PHONE_NUMBER	nvarchar(100)	INOUT	Phone number
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_OTHERMEMBERINFO
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @LASTNAME nvarchar(100) = null output,
                    @FIRSTNAME nvarchar(50) = null output,
                    @MIDDLENAME nvarchar(50) = null output,
                    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
                    @GENDERCODE tinyint = null output,
                    @PHONE_NUMBER nvarchar(100) = null output,
                    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;


                    select @DATALOADED = 1,
                            @LASTNAME = [CONSTITUENT].[KEYNAME],
                            @FIRSTNAME = [CONSTITUENT].[FIRSTNAME],
                            @MIDDLENAME = [CONSTITUENT].[MIDDLENAME],
                            @BIRTHDATE = [CONSTITUENT].[BIRTHDATE],
                            @GENDERCODE = [CONSTITUENT].[GENDERCODE],
                            @EMAILADDRESS = [EMAILADDRESS].[EMAILADDRESS],
                            @PHONE_NUMBER = [PHONE].[NUMBER]
                        from dbo.[CONSTITUENT]
                        left join dbo.[PHONE]
                            on [CONSTITUENT].[ID] = [PHONE].[CONSTITUENTID] and [PHONE].[ISPRIMARY] = 1
                        left join dbo.[EMAILADDRESS]
                            on [CONSTITUENT].[ID] = [EMAILADDRESS].[CONSTITUENTID] and [EMAILADDRESS].[ISPRIMARY] = 1
                        where [CONSTITUENT].[ID] = @ID


                    return 0;