USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSTITUENTMERGEPROCESS
The load procedure used by the edit dataform template "Constituent Merge Process Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTRECORDTYPEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSTITUENTMERGEPROCESS
(
@CONSTITUENTRECORDTYPEID uniqueidentifier = null output
)
as
set nocount on;
select
@CONSTITUENTRECORDTYPEID = ID
from
dbo.RECORDTYPE
where
upper(NAME) = 'CONSTITUENT';
return 0;