USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULINGEXCEPTION

The load procedure used by the edit dataform template "Scheduling Exceptions Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DIFFERENTGENDER	bit	INOUT	Assigned different gender than course
@DIFFERENTSCHOOL	bit	INOUT	Assigned different school than course
@DIFFERENTGRADELEVEL	bit	INOUT	Assigned different grade level than course
@ALREADYTAKEN	bit	INOUT	Has already taken course
@ALREADYREQUESTED	bit	INOUT	Has already requested course

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULINGEXCEPTION(
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @DIFFERENTGENDER bit = null output,
    @DIFFERENTSCHOOL bit = null output,
    @DIFFERENTGRADELEVEL bit = null output,
    @ALREADYTAKEN bit = null output,
    @ALREADYREQUESTED bit = null output
)
as

    set nocount on

    set @DATALOADED = 0
    set @TSLONG = 0

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @DIFFERENTGENDER = DIFFERENTGENDER,
        @DIFFERENTSCHOOL = DIFFERENTSCHOOL,
        @DIFFERENTGRADELEVEL = DIFFERENTGRADELEVEL,
        @ALREADYTAKEN = ALREADYTAKEN,
        @ALREADYREQUESTED = ALREADYREQUESTED        
    from dbo.SCHEDULINGEXCEPTION

    return 0