USP_DATAFORMTEMPLATE_VIEW_COURSE

The load procedure used by the view dataform template "Course View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SCHOOL	nvarchar(60)	INOUT	School
@NAME	nvarchar(60)	INOUT	Name
@DESCRIPTION	nvarchar(1024)	INOUT	Description
@COURSEID	nvarchar(12)	INOUT	Course ID
@ISINACTIVE	bit	INOUT	ISINACTIVE
@COURSETYPES	nvarchar(max)	INOUT	Course types

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_COURSE 
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @SCHOOL nvarchar(60) = null output,
                @NAME nvarchar(60) = null output,
                @DESCRIPTION nvarchar(1024) = null output,
                @COURSEID nvarchar(12) = null output,
                @ISINACTIVE bit = null output,
                @COURSETYPES nvarchar(max) = null output
            )
            as
                set nocount on;

                -- be sure to set this, in case the select returns no rows

                set @DATALOADED = 0;

                -- populate the output parameters, which correspond to fields on the form.  Note that

                -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

                -- will display a "no data loaded" message.

                select @DATALOADED = 1,
                       @COURSEID = dbo.COURSE.COURSEID,
                       @NAME = dbo.COURSE.NAME,
                       @DESCRIPTION = dbo.COURSE.DESCRIPTION,
                       @SCHOOL = dbo.CONSTITUENT.NAME,
                       @ISINACTIVE = dbo.COURSE.ISINACTIVE
                from dbo.COURSE
                    left join dbo.CONSTITUENT on dbo.COURSE.SCHOOLID = CONSTITUENT.ID
                where dbo.COURSE.ID = @ID

              select @COURSETYPES = case dbo.COURSE.SELECTEDTYPESCODE when 0 then 'All course types'
                                       when 1 then dbo.UDA_BUILDLIST(dbo.COURSETYPECODE.DESCRIPTION)
                                       when 2 then 'No course types' end
                                       from dbo.COURSE
                                       left outer join dbo.COURSETYPE
                                           on dbo.COURSE.ID = dbo.COURSETYPE.COURSEID
                                       left outer join dbo.COURSETYPECODE
                                           on dbo.COURSETYPE.COURSETYPECODEID = dbo.COURSETYPECODE.ID
                                       where dbo.COURSE.ID = @ID
                                       group by SELECTEDTYPESCODE

                return 0;