USP_DATAFORMTEMPLATE_PRELOAD_ADD_COUNTRYADDRESSFORMAT

The load procedure used by the edit dataform template "Country Address Format Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ADDRESSFORMATS	xml	INOUT	Address Formats

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_COUNTRYADDRESSFORMAT
                    (
                        @ADDRESSFORMATS xml = null output
                        )

                        as
                        set nocount on;

                        select @ADDRESSFORMATS = (
                                select
                                    ID as FORMATID,
                                    FORMATSTRING
                                from
                                    dbo.COUNTRYADDRESSFORMAT
                                for xml raw('ITEM'),type,elements,root('ADDRESSFORMATS'),BINARY BASE64
                            )

                        return 0;