USP_DATAFORMTEMPLATE_ADD_COURSEGRADING_PRELOAD

The load procedure used by the edit dataform template "Course Grading Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SCHOOLID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSEGRADING_PRELOAD
(
    @CONTEXTID uniqueidentifier,
    @SCHOOLID uniqueidentifier = null output
)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database

    select 
        @SCHOOLID = SCHOOLID
    from 
        dbo.COURSE
    where 
        ID = @CONTEXTID

    return 0;