USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMRESOURCEFROMRESOURCE

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

Parameters

Parameter	Parameter Type	Mode	Description
@RESOURCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RESOURCENAME	nvarchar(100)	INOUT	Resource
@PERTICKETQUANTITY	int	INOUT	Per ticket quantity
@ISPERTICKETITEM	bit	INOUT	Is Per Ticket Item
@FORMATTEDPERTICKETQUANTITY	nvarchar(25)	INOUT	Per ticket quantity

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PROGRAMRESOURCEFROMRESOURCE
                (
                    @RESOURCEID uniqueidentifier,
                    @RESOURCENAME nvarchar(100) = null output,
                    @PERTICKETQUANTITY int = null output,
                    @ISPERTICKETITEM bit = null output,
                    @FORMATTEDPERTICKETQUANTITY nvarchar(25) = null output
                )
                as

                set nocount on;

                select @RESOURCENAME = NAME,
                       @PERTICKETQUANTITY = PERTICKETQUANTITY,
                       @ISPERTICKETITEM = ISPERTICKETITEM,
                       @FORMATTEDPERTICKETQUANTITY = FORMATTEDPERTICKETQUANTITY
                from RESOURCE
                where RESOURCE.ID = @RESOURCEID