USP_DATAFORMTEMPLATE_ADD_SCHOOLPRIMARY_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SCHOOLPRIMARY_PRELOAD (
                        @ADDRESS_COUNTRYID uniqueidentifier = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @VALIDATIONCOUNTRIES xml = null output

                    ) as
                        set nocount on;

                        exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

                        select @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
                        select @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();                        

                        return 0;