USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_6

Edits a country record.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DESCRIPTION	nvarchar(100)	IN	Description
@ABBREVIATION	nvarchar(5)	IN	Abbreviation
@COUNTRYADDRESSFORMATID	uniqueidentifier	IN	Address format
@INACTIVE	bit	IN	Inactive
@ALLOWVALIDATION	bit	IN	Allow address validation
@VALIDATIONCOUNTRYCODE	tinyint	IN	Validate as
@ADDRESSLABEL	nvarchar(25)	IN	Address label
@CITYLABEL	nvarchar(25)	IN	City label
@REGIONLABEL	nvarchar(25)	IN	State label
@POSTCODELABEL	nvarchar(25)	IN	Postcode label
@DPCLABEL	nvarchar(25)	IN	DPC label
@CARTLABEL	nvarchar(25)	IN	CART label
@LOTLABEL	nvarchar(25)	IN	LOT label
@COUNTYLABEL	nvarchar(25)	IN	County label
@CONGRESSIONALDISTRICTLABEL	nvarchar(25)	IN	Congressional district label
@STATEHOUSEDISTRICTLABEL	nvarchar(25)	IN	State house district label
@STATESENATEDISTRICTLABEL	nvarchar(25)	IN	State senate district label
@LOCALPRECINCTLABEL	nvarchar(25)	IN	Local precinct label
@PHONEFORMATCODE	tinyint	IN	Phone format
@COUNTRYCODE	nvarchar(10)	IN	Country code

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_6
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DESCRIPTION nvarchar(100),
                @ABBREVIATION nvarchar(5),
                @COUNTRYADDRESSFORMATID uniqueidentifier,
                @INACTIVE bit,
                @ALLOWVALIDATION bit,
                @VALIDATIONCOUNTRYCODE tinyint,
                @ADDRESSLABEL nvarchar(25),
                @CITYLABEL nvarchar(25),
                @REGIONLABEL nvarchar(25),
                @POSTCODELABEL nvarchar(25),
                @DPCLABEL nvarchar(25),
                @CARTLABEL nvarchar(25),
                @LOTLABEL nvarchar(25),
                @COUNTYLABEL nvarchar(25),
                @CONGRESSIONALDISTRICTLABEL nvarchar(25),
                @STATEHOUSEDISTRICTLABEL nvarchar(25),
                @STATESENATEDISTRICTLABEL nvarchar(25),
                @LOCALPRECINCTLABEL nvarchar(25),
                @PHONEFORMATCODE tinyint,
                @COUNTRYCODE nvarchar(10)
            )
            as
                set nocount on;

                declare @ISO3166 nvarchar(2);
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COUNTRY_4 @ID = @ID, @ISO3166 = @ISO3166 output

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_7    @ID,
                                                                    @CHANGEAGENTID,
                                                                    @DESCRIPTION,
                                                                    @ABBREVIATION,
                                                                    @COUNTRYADDRESSFORMATID,
                                                                    @INACTIVE,
                                                                    @ALLOWVALIDATION,
                                                                    @VALIDATIONCOUNTRYCODE,
                                                                    @ADDRESSLABEL,
                                                                    @CITYLABEL,
                                                                    @REGIONLABEL,
                                                                    @POSTCODELABEL,
                                                                    @DPCLABEL,
                                                                    @CARTLABEL,
                                                                    @LOTLABEL,
                                                                    @COUNTYLABEL,
                                                                    @CONGRESSIONALDISTRICTLABEL,
                                                                    @STATEHOUSEDISTRICTLABEL,
                                                                    @STATESENATEDISTRICTLABEL,
                                                                    @LOCALPRECINCTLABEL,
                                                                    @PHONEFORMATCODE,
                                                                    @COUNTRYCODE,
                                                                    @ISO3166
                return 0;