USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMEVENTREGISTRATION_PRELOAD

The load procedure used by the edit dataform template "Order Event Registration Add Data Form"

Parameters

Parameter Parameter Type Mode Description
@SALESORDERID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@CONSTITUENTID uniqueidentifier INOUT Registrant/Guest
@REGISTRATIONS xml INOUT Registrations

Definition

Copy

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMEVENTREGISTRATION_PRELOAD
                (
                    @SALESORDERID uniqueidentifier,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @REGISTRATIONS xml = null output
                )
                as 
                    set nocount on;

                    select @CONSTITUENTID = [CONSTITUENTID]
                    from dbo.[SALESORDER]
                    where [ID] = @SALESORDERID

                return 0