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