USP_DATAFORMTEMPLATE_VIEW_CONSTITUENT

The load procedure used by the view dataform template "Constituent View 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.
@SEQUENCEID	int	INOUT	Raiser's Edge ID

Definition

Copy




CREATE PROCEDURE dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENT
(
    @ID UNIQUEIDENTIFIER,
    @DATALOADED BIT = 0 OUTPUT,
    @SEQUENCEID INT = NULL OUTPUT
)
AS
    SET NOCOUNT ON;

    SET @DATALOADED = 0;

    SELECT @DATALOADED = 1,
           @SEQUENCEID = SEQUENCEID
    FROM dbo.CONSTITUENT
    WHERE ID = @ID

    RETURN 0;