USP_DATAFORMTEMPLATE_EDIT_CLASS_MEETING_TEMPLATE_BYCLASSTEMPLATEID

The save procedure used by the edit dataform template "Class Meeting Template Edit Form (Wrapped)".

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.
@MEETINGS	xml	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CLASS_MEETING_TEMPLATE_BYCLASSTEMPLATEID 
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEETINGS xml
)


as

set nocount on

declare @CLASSID uniqueidentifier

select @CLASSID = CLASSID
from dbo.CLASSMEETINGTEMPLATE
join dbo.CLASSMEETINGGROUP on CLASSMEETINGGROUP.ID = CLASSMEETINGTEMPLATE.CLASSMEETINGGROUPID
where CLASSMEETINGTEMPLATE.ID = @ID

declare @r int
exec @r = dbo.USP_DATAFORMTEMPLATE_EDIT_CLASS_MEETING_TEMPLATE 
  @ID = @CLASSID, 
  @CHANGEAGENTID = @CHANGEAGENTID, 
  @MEETINGS = @MEETINGS

if @@error <> 0 
    begin
        if @r <> 0 return @r
        return 1
    end

return @r