USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHCONSTITUENTBUSINESSOWNERSHIPEXECSELECT
The save procedure used by the edit dataform template "Prospect Quick Search Constituent Business Ownership Executive Select Edit Data 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 |
| @EXECUTIVEADDRESSBLOCK | nvarchar(150) | IN | Home address block |
| @EXECUTIVECITY | nvarchar(50) | IN | Home city |
| @EXECUTIVESTATE | uniqueidentifier | IN | Home state |
| @EXECUTIVEPOSTCODE | nvarchar(10) | IN | Home post code |
| @INFOSOURCECODEID | uniqueidentifier | IN | Info source code ID |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHCONSTITUENTBUSINESSOWNERSHIPEXECSELECT(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@CONSTITUENTID uniqueidentifier,
@COUNTRYID uniqueidentifier,
@EXECUTIVEADDRESSBLOCK nvarchar(150),
@EXECUTIVECITY nvarchar(50),
@EXECUTIVESTATE uniqueidentifier,
@EXECUTIVEPOSTCODE 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;