USP_DATAFORMTEMPLATE_VIEW_BBNCBACKOFFICELINKINFO

The load procedure used by the view dataform template "NetCommunity Integration Back Office Link View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PAGEID	uniqueidentifier	INOUT	PAGEID
@CONSTITID	uniqueidentifier	INOUT	CONSTITID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BBNCBACKOFFICELINKINFO
                (
                    @ID int,
                    @DATALOADED bit = 0 output,
                    @PAGEID uniqueidentifier = null output,
                    @CONSTITID uniqueidentifier = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @PAGEID = (
                            select top 1
                                [NETCOMMUNITYDEFAULTCODEMAP].[CONSTITUENTLINKPAGEID]
                            from
                                dbo.NETCOMMUNITYDEFAULTCODEMAP
                        ),

                        @CONSTITID = (
                            select top 1
                                [ID]
                            from
                                dbo.CONSTITUENT
                            where
                                CONSTITUENT.SEQUENCEID = @ID
                        )

                    return 0;