USP_DATAFORMTEMPLATE_EDITLOAD_VSECONSTITUENCYORG

The load procedure used by the edit dataform template "Organization VSE Constituency Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@VSECONSTITUENCIES	xml	INOUT	VSE Constituencies
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_VSECONSTITUENCYORG
                    (
                        @VSECONSTITUENCIES XML = null output,
                        @DATALOADED bit = 0 output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 1;

                        set @VSECONSTITUENCIES = 
                                (select 
                                [ID], [VSECONSTITUENCY], [SEQUENCE] FROM dbo.VSECONSTITUENCY 
                                WHERE TYPECODE = 1 and (USAGETYPECODE = (select vsetypecode from dbo.vsetype) or USAGETYPECODE = 2)
                                ORDER BY SEQUENCE
                                for xml raw('ITEM'),type,elements,root('VSECONSTITUENCIES'),BINARY BASE64)

                        return 0;