USP_DATAFORMTEMPLATE_VIEW_MAPPINGCREDENTIALS
The load procedure used by the view dataform template "Mapping Credentials View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @USERNAME | nvarchar(100) | INOUT | User ID |
| @KEY | nvarchar(64) | INOUT | Key |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MAPPINGCREDENTIALS (
@DATALOADED bit = 0 output,
@USERNAME nvarchar(100) = null output,
@KEY nvarchar(64) = null output
) as
set nocount on;
set @DATALOADED = 0;
exec dbo.USP_GET_KEY_ACCESS;
if exists(select 1 from dbo.MAPPINGCREDENTIALS)
select
@DATALOADED = 1,
@USERNAME = USERNAME,
@KEY = '**********'
from
dbo.MAPPINGCREDENTIALS;
else begin
set @DATALOADED = 1;
set @USERNAME = '';
set @KEY = '';
end
close symmetric key sym_BBInfinity;
return 0;