USP_DATAFORMTEMPLATE_EDIT_COUNTRY

The save procedure used by the edit dataform template "Country Edit Form".

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COUNTRY
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@DESCRIPTION nvarchar(100),
@ABBREVIATION nvarchar(5),
@COUNTRYADDRESSFORMATID uniqueidentifier,
@INACTIVE bit
)
AS

set nocount on;

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

begin try
    update dbo.Country set
        DESCRIPTION = @DESCRIPTION,
        ABBREVIATION = @ABBREVIATION,
        COUNTRYADDRESSFORMATID = @COUNTRYADDRESSFORMATID,
        ACTIVE = ~ @INACTIVE,
        CHANGEDBYID = @CHANGEAGENTID
    where ID = @ID
end try
begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0;