USP_DATAFORMTEMPLATE_VIEW_EVENT_HASPRIMARY

The load procedure used by the view dataform template "Event Has Primary View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HASPRIMARY	nvarchar(10)	INOUT	Has primary coordinator

Definition

Copy



              CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENT_HASPRIMARY
              (
                  @ID uniqueidentifier,
                  @DATALOADED bit = 0 output,
                  @HASPRIMARY nvarchar(10) = null output
              )
              as
                  set nocount on;

                  set @DATALOADED = 0;

                  select 
                    @DATALOADED = 1,
                    @HASPRIMARY = case dbo.UFN_EVENTCOORDINATOR_PRIMARYCOUNT(ID) when 0 then 0 else 1 end
                  from dbo.EVENT
                  where ID = @ID

                  return 0;