USP_DATAFORMTEMPLATE_VIEW_SEARCHLISTREPLACEMENT

The load procedure used by the view dataform template "Search List Replacement 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.
@RECORDTYPE	nvarchar(50)	INOUT	Record type
@RECORDTYPEID	uniqueidentifier	INOUT	Record type ID
@REPLACEMENTSEARCHLIST	nvarchar(60)	INOUT	Replacement search list
@REPLACEMENTSEARCHLISTID	uniqueidentifier	INOUT	Replacement search list ID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SEARCHLISTREPLACEMENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @RECORDTYPE nvarchar(50) = null output,
    @RECORDTYPEID uniqueidentifier = null output,
    @REPLACEMENTSEARCHLIST nvarchar(60) = null output,
    @REPLACEMENTSEARCHLISTID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @RECORDTYPE = r.NAME,
           @RECORDTYPEID = r.ID,
           @REPLACEMENTSEARCHLIST = s2.NAME,
           @REPLACEMENTSEARCHLISTID = s2.ID
    from dbo.SEARCHLISTCATALOG s inner join
        dbo.RECORDTYPE r on s.RECORDTYPEID = r.ID left outer join
        dbo.SEARCHLISTSETTINGS t on s.ID = t.ID left outer join
        dbo.SEARCHLISTCATALOG s2 on t.REPLACEMENTSEARCHLISTID = s2.ID
    where s.ID = @ID

    return 0;