USP_DATAFORMTEMPLATE_EDITLOAD_BBPSLOGIN
The load procedure used by the edit dataform template "Blackbaud Payment Service Login Edit Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @USERNAME | nvarchar(100) | INOUT | Username |
| @PASSWORD | nvarchar(100) | INOUT | Password |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBPSLOGIN
(
@USERNAME nvarchar(100) = null output,
@PASSWORD nvarchar(100) = null output,
@DATALOADED bit = 0 output
)
as
set nocount on
exec dbo.USP_GET_KEY_ACCESS
begin try
select top 1
@DATALOADED = 1,
@USERNAME = convert(nvarchar(100), DecryptByKey(USERNAME))
from dbo.BBPSLOGIN
order by DATEADDED
if @DATALOADED = 0
begin
set @DATALOADED = 1
set @USERNAME = ''
end
close symmetric key sym_BBInfinity
end try
begin catch
close symmetric key sym_BBInfinity
end catch