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