USP_DATAFORMTEMPLATE_ADD_SCHOOL_PRELOAD

The load procedure used by the edit dataform template "School Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@PARENTSCHOOLID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PARENTSCHOOLNAME	nvarchar(100)	INOUT
@GENDERCODE	int	INOUT	School gender
@COMMENTCODE	int	INOUT	Grade comment entry

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SCHOOL_PRELOAD (
                        @ADDRESS_COUNTRYID uniqueidentifier = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @VALIDATIONCOUNTRIES xml = null output,
                        @PARENTSCHOOLID uniqueidentifier,
                        @PARENTSCHOOLNAME nvarchar(100) = null output,
                        @GENDERCODE int = null output,
                        @COMMENTCODE int = null output

                    ) as
                        set nocount on;

                        exec USP_DATAFORMTEMPLATE_ADD_SCHOOLPRIMARY_PRELOAD @ADDRESS_COUNTRYID output, @ZIPLOOKUPCOUNTRIES output, @VALIDATIONCOUNTRIES output;

                        if (not @PARENTSCHOOLID is null)
                            select @PARENTSCHOOLNAME = CONSTITUENT.KEYNAME, 
                                         @GENDERCODE = SCHOOL.GENDERCODE,
                                         @COMMENTCODE = SCHOOL.COMMENTCODE
                            from CONSTITUENT 
                                inner join SCHOOL
                                    on CONSTITUENT.ID = SCHOOL.ID
                            where CONSTITUENT.ID = @PARENTSCHOOLID;

                        else
                        begin
                            set @PARENTSCHOOLNAME = '';
                            set @GENDERCODE = 0;
                            set @COMMENTCODE = 1;
                        end

                        return 0;