USP_DATAFORMTEMPLATE_ADD_COURSEFACULTYRESOURCE

The save procedure used by the add dataform template "Course Faculty Resource Add Data Form".

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier INOUT The output parameter indicating the ID of the record added.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@COURSEID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@FACULTYID uniqueidentifier IN Faculty

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSEFACULTYRESOURCE
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
      @COURSEID uniqueidentifier,
      @FACULTYID uniqueidentifier
)
as

set nocount on;

declare @r int
exec @r = dbo.USP_FACULTYCOURSERESOURCE_ADD
  @ID = @ID output
  @CHANGEAGENTID = @CHANGEAGENTID
  @COURSEID = @COURSEID
  @FACULTYID = @FACULTYID

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