USP_DATAFORMTEMPLATE_VIEW_CONFIGUREWEALTHPOINTPAGEDATA

The load procedure used by the view dataform template "Configure WealthPoint Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@UNRESOLVEDSEARCHES	bit	INOUT	Unresolved searches
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONFIGUREWEALTHPOINTPAGEDATA
                (
                    @UNRESOLVEDSEARCHES bit = null output,
                    @DATALOADED            bit = 0 output
                )
                as
                    set nocount on;

                    set @DATALOADED = 1;

                    if (select count(ID) from WPSEARCHHISTORY where STATUSCODE in(0,1,2)) > 0
                    begin
                        set @UNRESOLVEDSEARCHES    = 1;    
                    end
                    else
                    begin
                        set @UNRESOLVEDSEARCHES = 0;
                    end

                    return 0;