USP_DATAFORMTEMPLATE_EDITLOAD_BBNCFUNDRAISERBATCHROW

The load procedure used by the edit dataform template "NetCommunity Fundraiser Batch Row Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	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.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@BBNCAPPEALID	int	INOUT	Blackbaud Internet Solutions appeal ID
@APPEALID	uniqueidentifier	INOUT	Appeal hidden
@APPEALFORDISPLAY	nvarchar(100)	INOUT	Appeal
@NEWTEAMS	int	INOUT	New teams hidden
@NEWTEAMFUNDRAISERS	int	INOUT	New team fundraisers hidden
@CHANGEDTEAMS	int	INOUT	Changed teams hidden
@CHANGEDTEAMFUNDRAISERS	int	INOUT	Changed team fundraisers hidden
@NEWTEAMSFORDISPLAY	int	INOUT	New teams
@NEWTEAMFUNDRAISERSFORDISPLAY	int	INOUT	New team fundraisers
@CHANGEDTEAMSFORDISPLAY	int	INOUT	Changed teams
@CHANGEDTEAMFUNDRAISERSFORDISPLAY	int	INOUT	Changed team fundraisers
@TEAMS	xml	INOUT	Teams hidden
@TEAMFUNDRAISERS	xml	INOUT	Team fundraisers hidden
@SEQUENCE	int	INOUT	Sequence
@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.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCFUNDRAISERBATCHROW
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                        @BBNCTRANID int = null output,
                        @BBNCAPPEALID int = null output,
                        @APPEALID uniqueidentifier = null output,
                        @APPEALFORDISPLAY nvarchar(100) = null output,
                        @NEWTEAMS int = null output,
                        @NEWTEAMFUNDRAISERS int = null output,
                        @CHANGEDTEAMS int = null output,
                        @CHANGEDTEAMFUNDRAISERS int = null output,
                        @NEWTEAMSFORDISPLAY int = null output,
                        @NEWTEAMFUNDRAISERSFORDISPLAY int = null output,
                        @CHANGEDTEAMSFORDISPLAY int = null output,
                        @CHANGEDTEAMFUNDRAISERSFORDISPLAY int = null output,
                        @TEAMS xml = null output,
                        @TEAMFUNDRAISERS xml = null output,
                        @SEQUENCE int = null output,
                        @TSLONG bigint = 0 output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @DATALOADED = 1,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID = [BATCHBBNCFUNDRAISER].[NETCOMMUNITYTRANSACTIONPROCESSORID],
                            @BBNCTRANID = [BATCHBBNCFUNDRAISER].[BBNCTRANID],
                            @BBNCAPPEALID = [BATCHBBNCFUNDRAISER].[BBNCAPPEALID],
                            @APPEALID = [BATCHBBNCFUNDRAISER].[APPEALID],
                            @APPEALFORDISPLAY = (select [APPEAL].[NAME] from dbo.APPEAL where [APPEAL].[ID] = [BATCHBBNCFUNDRAISER].[APPEALID]),
                            @NEWTEAMS = [BATCHBBNCFUNDRAISER].[NEWTEAMS],
                            @NEWTEAMFUNDRAISERS = [BATCHBBNCFUNDRAISER].[NEWTEAMFUNDRAISERS],
                            @CHANGEDTEAMS = [BATCHBBNCFUNDRAISER].[CHANGEDTEAMS],
                            @CHANGEDTEAMFUNDRAISERS = [BATCHBBNCFUNDRAISER].[CHANGEDTEAMFUNDRAISERS],
                            @NEWTEAMSFORDISPLAY = [BATCHBBNCFUNDRAISER].[NEWTEAMS],
                            @NEWTEAMFUNDRAISERSFORDISPLAY = [BATCHBBNCFUNDRAISER].[NEWTEAMFUNDRAISERS],
                            @CHANGEDTEAMSFORDISPLAY = [BATCHBBNCFUNDRAISER].[CHANGEDTEAMS],
                            @CHANGEDTEAMFUNDRAISERSFORDISPLAY = [BATCHBBNCFUNDRAISER].[CHANGEDTEAMFUNDRAISERS],
                            @TEAMS = [BATCHBBNCFUNDRAISER].[TEAMS],
                            @TEAMFUNDRAISERS = [BATCHBBNCFUNDRAISER].[TEAMFUNDRAISERS],
                            @SEQUENCE = [BATCHBBNCFUNDRAISER].[SEQUENCE],
                            @TSLONG = [BATCHBBNCFUNDRAISER].[TSLONG]
                        from
                            dbo.BATCHBBNCFUNDRAISER
                        where
                            BATCHBBNCFUNDRAISER.ID = @ID;

                        return 0;