USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECALENDARSYNC_2

The load procedure used by the edit dataform template "Exchange Calendar Synchronization Process Edit Form 2"

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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@APPUSERIDSETREGISTERID	uniqueidentifier	INOUT	Selection
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@APPUSERRECORDTYPEID	uniqueidentifier	INOUT
@APPLYTOCODE	tinyint	INOUT	Apply to
@CREATEITEMOPTIONCODE	tinyint	INOUT
@INCLUDEPENDINGINTERACTIONS	bit	INOUT	Pending constituent interactions
@INCLUDEPROSPECTPLANSTEPS	bit	INOUT	Prospect plan steps
@INCLUDEPENDINGSTEWARDSHIPSTEPS	bit	INOUT	Pending stewardship steps
@EXPECTEDDATEINTERVALCODE	tinyint	INOUT
@SPECIFICAPPUSERID	uniqueidentifier	INOUT	User
@PAGEDEFINITIONCATALOGID	uniqueidentifier	INOUT	Add link to
@DEFAULTREMINDERAMOUNT	int	INOUT	Reminder

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECALENDARSYNC_2
    (
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @NAME nvarchar(100) = null output,
        @DESCRIPTION nvarchar(250) = null output,
        @APPUSERIDSETREGISTERID uniqueidentifier = null output,
        @TSLONG bigint = 0 output,
        @APPUSERRECORDTYPEID uniqueidentifier = null output,
        @APPLYTOCODE tinyint = null output,
        @CREATEITEMOPTIONCODE tinyint = null output,                                                 
        @INCLUDEPENDINGINTERACTIONS bit = null output,
        @INCLUDEPROSPECTPLANSTEPS bit = null output,
        @INCLUDEPENDINGSTEWARDSHIPSTEPS bit = null output,
        @EXPECTEDDATEINTERVALCODE tinyint = null output,                                                 
        @SPECIFICAPPUSERID uniqueidentifier = null output,
        @PAGEDEFINITIONCATALOGID uniqueidentifier = null output,
        @DEFAULTREMINDERAMOUNT int = null output
    )
    as
    begin
        set nocount on;                                                        

        begin try
            select
                @NAME = EXCHANGECALENDARSYNC.NAME,
                @DESCRIPTION = EXCHANGECALENDARSYNC.DESCRIPTION,
                @APPUSERIDSETREGISTERID = EXCHANGECALENDARSYNC.APPUSERIDSETREGISTERID,
                @TSLONG = EXCHANGECALENDARSYNC.TSLONG, 
                @DATALOADED = 1,
                @APPUSERRECORDTYPEID = dbo.UFN_RECORDTYPE_GETIDBYNAME('Application User'),
                @APPLYTOCODE = EXCHANGECALENDARSYNC.APPLYTOCODE,
                @CREATEITEMOPTIONCODE = EXCHANGECALENDARSYNC.CREATEITEMOPTIONCODE,                                                                                                        
                @INCLUDEPENDINGINTERACTIONS = INCLUDEPENDINGINTERACTIONS,
                @INCLUDEPROSPECTPLANSTEPS = INCLUDEPROSPECTPLANSTEPS,
                @INCLUDEPENDINGSTEWARDSHIPSTEPS = INCLUDEPENDINGSTEWARDSHIPSTEPS,
                @EXPECTEDDATEINTERVALCODE = EXCHANGECALENDARSYNC.EXPECTEDDATEINTERVALCODE,
                @SPECIFICAPPUSERID = EXCHANGECALENDARSYNC.SPECIFICAPPUSERID,
                @PAGEDEFINITIONCATALOGID = EXCHANGECALENDARSYNC.PAGEDEFINITIONCATALOGID,
                @DEFAULTREMINDERAMOUNT = EXCHANGECALENDARSYNC.DEFAULTREMINDERAMOUNT
            from
                dbo.EXCHANGECALENDARSYNC
            where
                EXCHANGECALENDARSYNC.ID = @ID;        
        end try
        begin catch
            exec dbo.USP_RAISE_ERROR;    
            return 1;
        end catch 

        return 0;
    end