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