USP_DATAFORMTEMPLATE_ADD_PRELOAD_EVENTCOORDINATOR
The load procedure used by the edit dataform template "Event Coordinator Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @SELECTEDEVENTID | uniqueidentifier | INOUT | Event |
| @ISPRIMARY | bit | INOUT | Is primary |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_EVENTCOORDINATOR
(
@EVENTID uniqueidentifier,
@SELECTEDEVENTID uniqueidentifier = null output,
@ISPRIMARY bit = null output
)
as
set nocount on;
set @SELECTEDEVENTID = @EVENTID;
if not exists(select ID from dbo.EVENTCOORDINATOR where EVENTID = @EVENTID and ISPRIMARY = 1)
set @ISPRIMARY = 1;
return 0;