USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERGENERAL

The load procedure used by the view dataform template "Volunteer General 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.
@SPONSORNAME	nvarchar(400)	INOUT	Sponsor
@EMERGENCYCONTACTNAME	nvarchar(100)	INOUT	Emergency contact name
@EMERGENCYCONTACTPHONE	nvarchar(100)	INOUT	Emergency contact phone

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_VOLUNTEERGENERAL
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SPONSORNAME nvarchar(400) = null output,
                    @EMERGENCYCONTACTNAME nvarchar(100) = null output,
                    @EMERGENCYCONTACTPHONE nvarchar(100) = null output
                ) as    

                    set nocount on;

                    set @DATALOADED = 0;

                    select    @DATALOADED = 1,
                            @SPONSORNAME = SPONSOR.NAME,
                            @EMERGENCYCONTACTNAME = V.EMERGENCYCONTACTNAME, 
                            @EMERGENCYCONTACTPHONE = V.EMERGENCYCONTACTPHONE
                    from dbo.CONSTITUENT C
                    left join dbo.VOLUNTEER V on V.ID = C.ID
                    left outer join dbo.CONSTITUENT SPONSOR
                        on SPONSOR.ID = V.SPONSORID
                    where C.ID = @ID;

                    return 0;