USP_DATAFORMTEMPLATE_EDITLOAD_RE7WEBINTEGRATIONCONFIGURATION2

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@RE7DBID	int	INOUT
@RE7DBDESCRIPTION	nvarchar(128)	INOUT
@DBSELECTIONLOCKED	bit	INOUT
@RE7DBSERIALNUMBER	nvarchar(100)	INOUT
@RE7WEBSERVER	UDT_WEBADDRESS	INOUT
@PROVISIONINGKEY	nvarchar(12)	INOUT
@RE7USERNAME	nvarchar(128)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RE7WEBINTEGRATIONCONFIGURATION2
(
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
    @RE7DBID int = null output,
    @RE7DBDESCRIPTION nvarchar(128) = null output,
    @DBSELECTIONLOCKED bit = null output,
  @RE7DBSERIALNUMBER nvarchar(100) = null output,
  @RE7WEBSERVER dbo.UDT_WEBADDRESS = null output,
  @PROVISIONINGKEY nvarchar(12) = null output,
  @RE7USERNAME nvarchar(128) = null output
)
as

    set nocount on; 

    set @DATALOADED = 0
    set @TSLONG = 0

  if exists (select top 1 ID from dbo.RE7INTEGRATIONCONFIGURATION)
  begin
    select top 1
              @DATALOADED = 1,
                            @RE7DBID = RE7DBID,
                            @RE7DBDESCRIPTION = RE7DBDESCRIPTION,
                            @RE7DBSERIALNUMBER = RE7DBSERIALNUMBER,
                            @DBSELECTIONLOCKED = DBSELECTIONLOCKED,
              @RE7WEBSERVER = RERPWEBSERVICEURL,
              @PROVISIONINGKEY = RERPPROVISIONINGKEY,
                            @TSLONG = TSLONG
      from dbo.RE7INTEGRATIONCONFIGURATION;

    select top 1 
              @RE7USERNAME = RE7USERNAME
    from dbo.RE7INTEGRATIONCREDENTIALS
    where ID = @CURRENTAPPUSERID;
  end  
  else
  begin

  select @DATALOADED = 1,
         @RE7DBID = -1
  end

    return 0;