USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTPREFERENCE
The load procedure used by the edit dataform template "Receipt Preference Edit Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @TSLONG | bigint | INOUT | Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record. |
| @RECURRINGGIFTPAYMENTPREFERENCECODE | tinyint | INOUT | Recurring gift payments |
| @PLEDGEPAYMENTPREFERENCECODE | tinyint | INOUT | Pledge payments |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTPREFERENCE(
@DATALOADED bit = 0 output,
@TSLONG bigint = 0 output,
@RECURRINGGIFTPAYMENTPREFERENCECODE tinyint = null output,
@PLEDGEPAYMENTPREFERENCECODE tinyint = null output
)
as
set nocount on;
set @DATALOADED = 0
set @TSLONG = 0
if (select count(ID) from dbo.RECEIPTPREFERENCEINFO) = 0
begin
select
@RECURRINGGIFTPAYMENTPREFERENCECODE = 0,
@PLEDGEPAYMENTPREFERENCECODE = 0,
@DATALOADED = 1
end
else
begin
select top 1
@RECURRINGGIFTPAYMENTPREFERENCECODE = RECURRINGGIFTPAYMENTPREFERENCECODE,
@PLEDGEPAYMENTPREFERENCECODE = PLEDGEPAYMENTPREFERENCECODE,
@DATALOADED = 1,
@TSLONG = TSLONG
from
dbo.RECEIPTPREFERENCEINFO;
end
return 0;