USP_DATAFORMTEMPLATE_ADD_VOLUNTEERSKILLLEVEL_PRELOAD

The load procedure used by the edit dataform template "Volunteer Skill Level Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SKILLLEVELS	xml	INOUT	Skill levels

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_VOLUNTEERSKILLLEVEL_PRELOAD
                    (
                        @SKILLLEVELS XML = null output
                    )
                    as
                        set nocount on;

                        set @SKILLLEVELS = 
                                (select 
                                [ID], [DESCRIPTION], [SEQUENCE] FROM dbo.VOLUNTEERSKILLLEVEL ORDER BY SEQUENCE
                                for xml raw('ITEM'),type,elements,root('SKILLLEVELS'),BINARY BASE64)

                        return 0;