USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNPLANNEDGIFTLETTERCODESPROCESS
The load procedure used by the edit dataform template "Assign Planned Gift Letters Process Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDTYPEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNPLANNEDGIFTLETTERCODESPROCESS
(
@RECORDTYPEID uniqueidentifier = null output
)
as
set nocount on;
select
@RECORDTYPEID = ID
from
dbo.RECORDTYPE
where
upper(NAME) = 'PLANNED GIFT';
return 0;