USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEMEMBERSHIPMAP
The load procedure used by the edit dataform template "Donor Challenge Membership Map Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@DONORCHALLENGEID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
@TYPECODE | tinyint | INOUT | Donor challenge type code |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEMEMBERSHIPMAP
(
@DONORCHALLENGEID uniqueidentifier,
@TYPECODE tinyint = null output
)
as
begin
set nocount on;
select
@TYPECODE = TYPECODE
from
dbo.DONORCHALLENGE
where
ID = @DONORCHALLENGEID;
return 0;
end