USP_DATAFORMTEMPLATE_EDITLOAD_FAF_FUNDRAISING_ROLES_CONTENT

The load procedure used by the edit dataform template "FAF Fundraising Roles Content 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.
@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.
@REGISTRATIONPAGEID	int	INOUT	Registrationpage
@STARTACOMPANYTITLE	nvarchar(500)	INOUT	Startacompanytitle
@STARTACOMPANYDESCRIPTION	nvarchar(510)	INOUT	Startacompanydescription
@STARTACOMPANYIMAGEID	int	INOUT	Startacompanyimageid
@STARTATEAMTITLE	nvarchar(500)	INOUT	Startateamtitle
@STARTATEAMDESCRIPTION	nvarchar(510)	INOUT	Startateamdescription
@STARTATEAMTITLEIMAGEID	int	INOUT	Startateamtitleimageid
@STARTATEAMUNDERGROUPTITLE	nvarchar(500)	INOUT	Startateamundergrouptitle
@STARTATEAMUNDERGROUPDESCRIPTION	nvarchar(510)	INOUT	Startateamundergroupdescription
@STARTATEAMUNDERGROUPIMAGEID	int	INOUT	Startateamundergroupimageid
@STARTATEAMINDEPENDENTTITLE	nvarchar(500)	INOUT	Startateamindependenttitle
@STARTATEAMINDEPENDENTDESCRIPTION	nvarchar(510)	INOUT	Startateamindependentdescription
@STARTATEAMINDEPENDENTIMAGEID	int	INOUT	Startateamindependentimageid
@JOINATEAMTITLE	nvarchar(500)	INOUT	Joinateamtitle
@JOINATEAMDESCRIPTION	nvarchar(510)	INOUT	Joinateamdescription
@JOINATEAMTITLEIMAGEID	int	INOUT	Joinateamtitleimageid
@STARTAHOUSEHOLDTITLE	nvarchar(500)	INOUT	Startahouseholdtitle
@STARTAHOUSEHOLDDESCRIPTION	nvarchar(510)	INOUT	Startahouseholddescription
@STARTAHOUSEHOLDIMAGEID	int	INOUT	Startahouseholdimageid
@STARTAHOUSEHOLDUNDERCOMPANYTITLE	nvarchar(500)	INOUT	Startahouseholdundercompanytitle
@STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdundercompanydescription
@STARTAHOUSEHOLDUNDERCOMPANYIMAGEID	int	INOUT	Startahouseholdundercompanyimageid
@STARTAHOUSEHOLDUNDERTEAMTITLE	nvarchar(500)	INOUT	Startahouseholdunderteamtitle
@STARTAHOUSEHOLDUNDERTEAMDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdunderteamdescription
@STARTAHOUSEHOLDUNDERTEAMIMAGEID	int	INOUT	Startahouseholdunderteamimageid
@STARTAHOUSEHOLDINDEPENDENTTITLE	nvarchar(500)	INOUT	Startahouseholdindependenttitle
@STARTAHOUSEHOLDINDEPENDENTDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdindependentdescription
@STARTAHOUSEHOLDINDEPENDENTIMAGEID	int	INOUT	Startahouseholdindependentimageid
@JOINASINDIVIDUALTITLE	nvarchar(500)	INOUT	Joinasindividualtitle
@JOINASINDIVIDUALDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualdescription
@JOINASINDIVIDUALIMAGEID	int	INOUT	Joinasindividualimageid
@JOINASINDIVIDUALUNDERCOMPANYTITLE	nvarchar(500)	INOUT	Joinasindividualundercompanytitle
@JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualundercompanydescription
@JOINASINDIVIDUALUNDERCOMPANYIMAGEID	int	INOUT	Joinasindividualundercompanyimageid
@JOINASINDIVIDUALPARTICIPANTTITLE	nvarchar(500)	INOUT	Joinasindividualparticipanttitle
@JOINASINDIVIDUALPARTICIPANTDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualparticipantdescription
@JOINASINDIVIDUALPARTICIPANTIMAGEID	int	INOUT	Joinasindividualparticipantimageid

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FAF_FUNDRAISING_ROLES_CONTENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @REGISTRATIONPAGEID integer = null output,
    @STARTACOMPANYTITLE nvarchar(500) = null output,
    @STARTACOMPANYDESCRIPTION nvarchar(510) = null output,
    @STARTACOMPANYIMAGEID int = null output,
    @STARTATEAMTITLE nvarchar(500) = null output,
    @STARTATEAMDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMTITLEIMAGEID int = null output,
    @STARTATEAMUNDERGROUPTITLE nvarchar(500) = null output,
    @STARTATEAMUNDERGROUPDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMUNDERGROUPIMAGEID int = null output,
    @STARTATEAMINDEPENDENTTITLE nvarchar(500) = null output,
    @STARTATEAMINDEPENDENTDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMINDEPENDENTIMAGEID int = null output,
    @JOINATEAMTITLE nvarchar(500) = null output,
    @JOINATEAMDESCRIPTION nvarchar(510) = null output,
    @JOINATEAMTITLEIMAGEID int = null output,
    @STARTAHOUSEHOLDTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDIMAGEID int = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID int = null output,
    @STARTAHOUSEHOLDUNDERTEAMTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDUNDERTEAMIMAGEID int = null output,
    @STARTAHOUSEHOLDINDEPENDENTTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDINDEPENDENTIMAGEID int = null output,
    @JOINASINDIVIDUALTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALIMAGEID int = null output,
    @JOINASINDIVIDUALUNDERCOMPANYTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALUNDERCOMPANYIMAGEID int = null output,
    @JOINASINDIVIDUALPARTICIPANTTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALPARTICIPANTDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALPARTICIPANTIMAGEID int = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @REGISTRATIONPAGEID = REGISTRATIONPAGEID, 
        @STARTACOMPANYTITLE = STARTACOMPANYTITLE, 
        @STARTACOMPANYDESCRIPTION = STARTACOMPANYDESCRIPTION, 
        @STARTACOMPANYIMAGEID = STARTACOMPANYIMAGEID, 
        @STARTATEAMTITLE = STARTATEAMTITLE, 
        @STARTATEAMDESCRIPTION = STARTATEAMDESCRIPTION, 
        @STARTATEAMTITLEIMAGEID = STARTATEAMTITLEIMAGEID, 
        @STARTATEAMUNDERGROUPTITLE = STARTATEAMUNDERGROUPTITLE, 
        @STARTATEAMUNDERGROUPDESCRIPTION = STARTATEAMUNDERGROUPDESCRIPTION, 
        @STARTATEAMUNDERGROUPIMAGEID = STARTATEAMUNDERGROUPIMAGEID, 
        @STARTATEAMINDEPENDENTTITLE = STARTATEAMINDEPENDENTTITLE, 
        @STARTATEAMINDEPENDENTDESCRIPTION = STARTATEAMINDEPENDENTDESCRIPTION, 
        @STARTATEAMINDEPENDENTIMAGEID = STARTATEAMINDEPENDENTIMAGEID, 
        @JOINATEAMTITLE = JOINATEAMTITLE, 
        @JOINATEAMDESCRIPTION = JOINATEAMDESCRIPTION, 
        @JOINATEAMTITLEIMAGEID = JOINATEAMTITLEIMAGEID, 
        @STARTAHOUSEHOLDTITLE = STARTAHOUSEHOLDTITLE, 
        @STARTAHOUSEHOLDDESCRIPTION = STARTAHOUSEHOLDDESCRIPTION, 
@STARTAHOUSEHOLDIMAGEID = STARTAHOUSEHOLDIMAGEID, 
        @STARTAHOUSEHOLDUNDERCOMPANYTITLE = STARTAHOUSEHOLDUNDERCOMPANYTITLE, 
        @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION = STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION, 
        @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID = STARTAHOUSEHOLDUNDERCOMPANYIMAGEID, 
        @STARTAHOUSEHOLDUNDERTEAMTITLE = STARTAHOUSEHOLDUNDERTEAMTITLE, 
        @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION = STARTAHOUSEHOLDUNDERTEAMDESCRIPTION, 
        @STARTAHOUSEHOLDUNDERTEAMIMAGEID = STARTAHOUSEHOLDUNDERTEAMIMAGEID, 
        @STARTAHOUSEHOLDINDEPENDENTTITLE = STARTAHOUSEHOLDINDEPENDENTTITLE, 
        @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION = STARTAHOUSEHOLDINDEPENDENTDESCRIPTION, 
        @STARTAHOUSEHOLDINDEPENDENTIMAGEID = STARTAHOUSEHOLDINDEPENDENTIMAGEID, 
        @JOINASINDIVIDUALTITLE = JOINASINDIVIDUALTITLE, 
        @JOINASINDIVIDUALDESCRIPTION = JOINASINDIVIDUALDESCRIPTION, 
        @JOINASINDIVIDUALIMAGEID = JOINASINDIVIDUALIMAGEID, 
        @JOINASINDIVIDUALUNDERCOMPANYTITLE = JOINASINDIVIDUALUNDERCOMPANYTITLE, 
        @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION = JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION, 
        @JOINASINDIVIDUALUNDERCOMPANYIMAGEID = JOINASINDIVIDUALUNDERCOMPANYIMAGEID, 
        @JOINASINDIVIDUALPARTICIPANTTITLE = JOINASINDIVIDUALPARTICIPANTTITLE, 
        @JOINASINDIVIDUALPARTICIPANTDESCRIPTION = JOINASINDIVIDUALPARTICIPANTDESCRIPTION, 
        @JOINASINDIVIDUALPARTICIPANTIMAGEID = JOINASINDIVIDUALPARTICIPANTIMAGEID
    from dbo.FAFFUNDRAISINGROLESCONTENT
    where ID = @ID

    return 0;