USP_DATAFORMTEMPLATE_ADD_PDACCOUNTSTRUCTURE2_PRELOAD2

The load procedure used by the edit dataform template "Account Structure Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@FENXT	bit	INOUT
@PROJECTCOUNT	int	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTSTRUCTURE2_PRELOAD2
                    (
                        @SYSTEMID  uniqueidentifier,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @FENXT bit = null output,
                        @PROJECTCOUNT int = null output
                    )
                    as

                        set nocount on;
                        set @PDACCOUNTSYSTEMID = @SYSTEMID

                        if exists (select 1 from dbo.FENXTINTEGRATION where PDACCOUNTSYSTEMID = @SYSTEMID)
                            begin
                                set @FENXT = 1;
                                select @PROJECTCOUNT = count(*) from dbo.FENXTPROJECT where PDACCOUNTSYSTEMID = @SYSTEMID;
                            end
                        else
                            set @FENXT = 0;

                    return 0;