USP_DATAFORMTEMPLATE_EDITLOAD_EXTERNALSERVICECONFIGURATION

The load procedure used by the edit dataform template "External Service Configuration Edit"

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.
@HOST	nvarchar(2048)	INOUT	Host URL
@USER	nvarchar(2048)	INOUT	User name
@PASS	nvarchar(2048)	INOUT	Password
@USESECURE	nvarchar(2048)	INOUT	Use SSL
@CHUNKSIZE	nvarchar(2048)	INOUT	Merge Data Chunk Size (in bytes)

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXTERNALSERVICECONFIGURATION(
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
              @HOST nvarchar(2048) = null output,
              @USER nvarchar(2048) = null output,
              @PASS nvarchar(2048) = null output,
            @USESECURE nvarchar(2048) = null output,
            @CHUNKSIZE nvarchar(2048) = null output
          )
          as

              set nocount on;

            exec dbo.USP_GET_KEY_ACCESS;

              set @DATALOADED = 0
              set @TSLONG = 0

            begin try
                select top 1 
                     @DATALOADED = 1,
                     @HOST = BlackbaudServiceHost, 
                     @USER = decryptbykey(BlackbaudServiceUser),
                     @PASS = decryptbykey(BlackbaudServicePassword),
                     @USESECURE = BlackbaudServiceUseSecureServices,
                     @CHUNKSIZE = ChunkSize
                from (select NAME, VALUE from dbo.EXTERNALSERVICECONFIGURATION)  D
                      pivot(max(VALUE) for NAME
                          in(BlackbaudServiceHost, BlackbaudServiceUser, BlackbaudServicePassword, BlackbaudServiceUseSecureServices, ChunkSize)) as P;

              close symmetric key sym_BBInfinity;
            end try
            begin catch
              close symmetric key sym_BBInfinity;
            end catch




              return 0;