USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSEGMENTMAPSUMMARY

The load procedure used by the view dataform template "Account Segment Map 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.
@VERBAGE1	nvarchar(400)	INOUT
@VERBAGE2	nvarchar(400)	INOUT
@ISCONSTANTVALUE	bit	INOUT	ISCONSTANTVALUE
@ISCOMPOSITE	bit	INOUT	ISCOMPOSITE

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSEGMENTMAPSUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @VERBAGE1 nvarchar(400) = null output,
    @VERBAGE2 nvarchar(400) = null output,
    @ISCONSTANTVALUE bit = null output,
    @ISCOMPOSITE bit = null  output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @ISCONSTANTVALUE = ISCONSTANTVALUE from dbo.PDACCOUNTSTRUCTURE where ID = @ID

    if exists(select 1 from dbo.PDACCOUNTSTRUCTURE where SEGMENTTYPE = 4 and ID = @ID)
        set @ISCOMPOSITE = 1


    select @DATALOADED = 1,
    @ISCONSTANTVALUE = @ISCONSTANTVALUE,
    @ISCOMPOSITE = @ISCOMPOSITE

    return 0;