USP_DATAFORMTEMPLATE_ADD_COURSERESTRICTION_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@COURSEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SCHOOLID	uniqueidentifier	INOUT
@COURSENAME	nvarchar(60)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COURSERESTRICTION_PRELOAD
(
    @COURSEID uniqueidentifier,
    @SCHOOLID uniqueidentifier = null output,
    @COURSENAME nvarchar(60) = null output
)
as
    set nocount on;

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

    select 
        @SCHOOLID = SCHOOLID,
        @COURSENAME = NAME
    from 
        dbo.COURSE
    where 
        ID = @COURSEID

    return 0;