USP_DATAFORMTEMPLATE_VIEW_TRIBUTE

The load procedure used by the view dataform template "Tribute View"

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.
@TRIBUTETYPECODEID	uniqueidentifier	INOUT	Tribute type ID
@TRIBUTETYPE	nvarchar(20)	INOUT	Tribute type
@TRIBUTETEXT	nvarchar(255)	INOUT	Tribute text
@TRIBUTEEID	uniqueidentifier	INOUT	Tributee ID
@TRIBUTEE	nvarchar(255)	INOUT	Tributee

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_TRIBUTE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TRIBUTETYPECODEID uniqueidentifier = null output,
    @TRIBUTETYPE nvarchar(20) = null output,
    @TRIBUTETEXT nvarchar(255) = null output,
    @TRIBUTEEID uniqueidentifier = null output,
    @TRIBUTEE nvarchar(255) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @TRIBUTETYPECODEID = TRIBUTETYPECODEID,
           @TRIBUTETYPE = TRIBUTETYPE.DESCRIPTION,
           @TRIBUTETEXT = TRIBUTETEXT,
           @TRIBUTEEID = TRIBUTEEID,
           @TRIBUTEE = NF.NAME

    from dbo.TRIBUTE
        inner join dbo.TRIBUTETYPECODE TRIBUTETYPE on TRIBUTE.TRIBUTETYPECODEID = TRIBUTETYPE.ID
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(TRIBUTE.TRIBUTEEID) NF

    where TRIBUTE.ID = @ID

    return 0;