USP_DATAFORMTEMPLATE_EDIT_SPONOSRHSIPOPPORTUNITYNOTE_2

The save procedure used by the edit dataform template "Sponsorship Opportunity Note Edit Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DATEENTERED	datetime	IN	Date
@TITLE	nvarchar(50)	IN	Title
@AUTHORID	uniqueidentifier	IN	Author
@TEXTNOTE	nvarchar(max)	IN	Notes
@NOTETYPECODEID	uniqueidentifier	IN	Type
@HTMLNOTE	nvarchar(max)	IN	Notes

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONOSRHSIPOPPORTUNITYNOTE_2 
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @DATEENTERED datetime, 
            @TITLE nvarchar(50),
            @AUTHORID uniqueidentifier,
            @TEXTNOTE nvarchar(max),
            @NOTETYPECODEID uniqueidentifier,
            @HTMLNOTE nvarchar(max)
        )
        as

          set nocount on;
        declare @CURRENTDATE datetime;

                begin try
                if @CHANGEAGENTID is null  
                  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                set @CURRENTDATE = getdate();

                update
                    dbo.[SPONSORSHIPOPPORTUNITYNOTE]
                set [DATEENTERED] = @DATEENTERED,
                  [TITLE] = @TITLE,
                    [AUTHORID] = @AUTHORID,
                    [TEXTNOTE] = @TEXTNOTE,
                    [SPROPPNOTETYPECODEID] = @NOTETYPECODEID,
                    [HTMLNOTE] = @HTMLNOTE,
                    [CHANGEDBYID] = @CHANGEAGENTID,
                    [DATECHANGED] = @CURRENTDATE
                where
                    [ID] = @ID;
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;