USP_DATAFORMTEMPLATE_ADD_INDIVIDUALALIAS

The save procedure used by the add dataform template "Individual Alias Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ALIASTYPECODEID	uniqueidentifier	IN	Type
@KEYNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@TITLECODEID	uniqueidentifier	IN	Title
@TITLE2CODEID	uniqueidentifier	IN	Title 2
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SUFFIX2CODEID	uniqueidentifier	IN	Suffix 2

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALALIAS (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @CONSTITUENTID uniqueidentifier,
                        @ALIASTYPECODEID uniqueidentifier = null,
                        @KEYNAME nvarchar(100) = '',
                        @FIRSTNAME nvarchar(50) = '',
                        @MIDDLENAME nvarchar(50) = '',
                        @TITLECODEID uniqueidentifier = null,
                        @TITLE2CODEID uniqueidentifier = null,
                        @SUFFIXCODEID uniqueidentifier = null,
                        @SUFFIX2CODEID uniqueidentifier = null
                        )
                    as
                    set nocount on;

                    declare @IGNOREDUPLICATE bit = 0;--if we are here we don't want to ignore the duplicate error message

                    begin try
                        exec USP_ADD_INDIVIDUAL_ALIAS @ID,
                            @CHANGEAGENTID,
                            @CONSTITUENTID,
                            @ALIASTYPECODEID,
                            @KEYNAME,
                            @FIRSTNAME,
                            @MIDDLENAME,
                            @TITLECODEID,
                            @TITLE2CODEID,
                            @SUFFIXCODEID,
                            @SUFFIX2CODEID,
                            @IGNOREDUPLICATE;
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR;

                        return 1;
                    end catch

                    return 0;