USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMSTAFFRESOURCEFROMRESOURCE

The load procedure used by the edit dataform template "Program Staff Resource Add From Resource Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@VOLUNTEERTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RESOURCENAME	nvarchar(100)	INOUT	Resource

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMSTAFFRESOURCEFROMRESOURCE
                (
                    @VOLUNTEERTYPEID uniqueidentifier,
                    @RESOURCENAME nvarchar(100) = null output
                )
                as

                set nocount on;

                select @RESOURCENAME = NAME
                from VOLUNTEERTYPE
                where VOLUNTEERTYPE.ID = @VOLUNTEERTYPEID