USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSTRUCTURE

The load procedure used by the view dataform template "Account Structure View Form"

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT Output parameter indicating whether or not data was actually loaded.
@VERBAGE1 nvarchar(400) INOUT
@VERBAGE2 nvarchar(400) INOUT

Definition

Copy

                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSTRUCTURE
                (
                    @DATALOADED bit = 0 output,
                    @VERBAGE1 nvarchar(400) = null output,
                    @VERBAGE2 nvarchar(400) = null output
                )
                as
                    set nocount on;

                    -- be sure to set this, in case the select returns no rows
                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1
                return 0;