USP_DATAFORMTEMPLATE_VIEW_RE7INTEGRATIONCONFIGURATION

The load procedure used by the view dataform template "RE7 Integration Configuration View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@RE7DBDESCRIPTION	nvarchar(128)	INOUT	The Raiser's Edge database
@RE7USERNAME	nvarchar(128)	INOUT	The Raiser's Edge user name
@RE7WINDOWSAUTHENTICATION	bit	INOUT	Use Windows Authentication
@RE7DBSERIALNUMBER	nvarchar(100)	INOUT	The Raiser's Edge database serial number

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RE7INTEGRATIONCONFIGURATION (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @RE7DBDESCRIPTION nvarchar(128) = null output,
                    @RE7USERNAME nvarchar(128) = null output,
                    @RE7WINDOWSAUTHENTICATION bit = null output,
                    @RE7DBSERIALNUMBER nvarchar(100) = null output
                ) as
                    set nocount on;

                    set @DATALOADED = 1;

                    select top 1
                        @RE7DBDESCRIPTION = RE7INTEGRATIONCONFIGURATION.RE7DBDESCRIPTION,        
                        @RE7DBSERIALNUMBER = RE7INTEGRATIONCONFIGURATION.RE7DBSERIALNUMBER        
                    from
                        dbo.RE7INTEGRATIONCONFIGURATION;

                    select
                        @RE7USERNAME = RE7INTEGRATIONCREDENTIALS.RE7USERNAME,
                        @RE7WINDOWSAUTHENTICATION = RE7WINDOWSAUTHENTICATION
                    from
                        dbo.RE7INTEGRATIONCREDENTIALS
                    where
                        RE7INTEGRATIONCREDENTIALS.ID = @CURRENTAPPUSERID;

                    return 0;