USP_DATAFORMTEMPLATE_VIEW_BANKGENERAL

The load procedure used by the view dataform template "Bank General 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.
@ROUTINGNUMBER	nvarchar(9)	INOUT	Routing number
@SORTCODE	nvarchar(6)	INOUT	Sort code
@NAME	nvarchar(154)	INOUT	Name
@DEFAULTBANKINGSYSTEMID	uniqueidentifier	INOUT
@DEFAULTBIC	nvarchar(11)	INOUT
@DEFAULTBANKCODE	nvarchar(25)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BANKGENERAL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ROUTINGNUMBER nvarchar(9) = null output,
    @SORTCODE nvarchar(6) = null output,
    @NAME nvarchar(154) = null output,
    @DEFAULTBANKINGSYSTEMID uniqueidentifier = null output,
    @DEFAULTBIC nvarchar(11) = null output,
    @DEFAULTBANKCODE nvarchar(25) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @DEFAULTBANKINGSYSTEMID = BANK.DEFAULTBANKINGSYSTEMID,
        @ROUTINGNUMBER = BANK.DEFAULTROUTINGNUMBER,
        @SORTCODE = BANK.DEFAULTSORTCODE,
        @DEFAULTBIC = BANK.DEFAULTBIC,
        @DEFAULTBANKCODE = BANK.DEFAULTBANKCODE,
        @NAME = CONSTITUENT.NAME   
    from 
        dbo.CONSTITUENT
        left join dbo.BANK on BANK.ID = CONSTITUENT.ID
    where 
        CONSTITUENT.ID = @ID

    return 0;