USP_DATAFORMTEMPLATE_ADD_PRELOAD_VOLUNTEERASSIGNMENTS

The load procedure used by the edit dataform template "VolunteerAssignmentsDayView Add Data Form"

Parameters

Parameter Parameter Type Mode Description
@VOLUNTEERID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@NAME nvarchar(700) INOUT Volunteer

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_VOLUNTEERASSIGNMENTS
(
    @VOLUNTEERID uniqueidentifier,
    @NAME nvarchar(700) = null output
)
as

set nocount on;

select @NAME = NF.NAME 
from dbo.UFN_CONSTITUENT_DISPLAYNAME(@VOLUNTEERID) NF

return 0