USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHCONSTITUENTSELECT

The save procedure used by the edit dataform template "Prospect Quick Search Constituent Real Estate Select 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.
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@COUNTRYID	uniqueidentifier	IN	Country ID
@PROPERTYADDRESSBLOCK	nvarchar(150)	IN	Property address block
@PROPERTYUNITNUMBER	nvarchar(25)	IN	Property unit number
@PROPERTYCITY	nvarchar(50)	IN	Property city
@PROPERTYSTATE	uniqueidentifier	IN	Property state
@PROPERTYPOSTCODE	nvarchar(10)	IN	Property post code
@MAILINGADDRESSBLOCK	nvarchar(150)	IN	Property address block
@MAILINGUNITNUMBER	nvarchar(25)	IN	Property unit number
@MAILINGCITY	nvarchar(50)	IN	Property city
@MAILINGSTATE	uniqueidentifier	IN	Property state
@MAILINGPOSTCODE	nvarchar(10)	IN	Property post code
@ASSESSEEMAILINGADDRESSBLOCK	nvarchar(150)	IN	Property address block
@ASSESSEEMAILINGADDRESSUNITNUMBER	nvarchar(25)	IN	Property unit number
@ASSESSEEMAILINGCITY	nvarchar(50)	IN	Property city
@ASSESSEEMAILINGSTATE	uniqueidentifier	IN	Property state
@ASSESSEEMAILINGPOSTCODE	nvarchar(10)	IN	Property post code
@BUYERMAILINGADDRESSBLOCK	nvarchar(150)	IN	Property address block
@BUYERMAILINGADDRESSUNITNUMBER	nvarchar(25)	IN	Property unit number
@BUYERMAILINGCITY	nvarchar(50)	IN	Property city
@BUYERMAILINGSTATE	uniqueidentifier	IN	Property state
@BUYERMAILINGPOSTCODE	nvarchar(10)	IN	Property post code
@INFOSOURCECODEID	uniqueidentifier	IN	Info source code ID

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHCONSTITUENTSELECT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier,
    @COUNTRYID uniqueidentifier,
    @PROPERTYADDRESSBLOCK nvarchar(150),
    @PROPERTYUNITNUMBER nvarchar(25),
    @PROPERTYCITY nvarchar(50),
    @PROPERTYSTATE uniqueidentifier,
    @PROPERTYPOSTCODE nvarchar(10),
    @MAILINGADDRESSBLOCK nvarchar(150),
    @MAILINGUNITNUMBER nvarchar(25),
    @MAILINGCITY nvarchar(50),
    @MAILINGSTATE uniqueidentifier,
    @MAILINGPOSTCODE nvarchar(10),
    @ASSESSEEMAILINGADDRESSBLOCK nvarchar(150),
    @ASSESSEEMAILINGADDRESSUNITNUMBER nvarchar(25),
    @ASSESSEEMAILINGCITY nvarchar(50),
    @ASSESSEEMAILINGSTATE uniqueidentifier,
    @ASSESSEEMAILINGPOSTCODE nvarchar(10),
    @BUYERMAILINGADDRESSBLOCK nvarchar(150),
    @BUYERMAILINGADDRESSUNITNUMBER nvarchar(25),
    @BUYERMAILINGCITY nvarchar(50),
    @BUYERMAILINGSTATE uniqueidentifier,
    @BUYERMAILINGPOSTCODE nvarchar(10),
    @INFOSOURCECODEID uniqueidentifier
)
as

    set nocount on;

    begin try
        if @CONSTITUENTID is null begin
            raiserror('Please select a constituent.', 13, 1);
            return 1;
        end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;