USP_DATAFORMTEMPLATE_VIEW_MKTSOURCECODE

The load procedure used by the view dataform template "Source Code 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@SAMPLE	nvarchar(255)	INOUT	Sample
@ISACTIVE	bit	INOUT	Active
@ISDEFAULT	bit	INOUT	Default
@INUSE	bit	INOUT	Is in use
@MAXSEQUENCE	tinyint	INOUT	Maximum sequence
@MINSEQUENCE	tinyint	INOUT	Minimum sequence
@TOTALLENGTH	int	INOUT
@ISHISTORICAL	bit	INOUT
@SITE	nvarchar(250)	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSOURCECODE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(100)= null output,
  @DESCRIPTION nvarchar(255) = null output,
  @SAMPLE nvarchar(255) = null output,
  @ISACTIVE bit = null output,
  @ISDEFAULT bit = null output,
  @INUSE bit = null output,
  @MAXSEQUENCE tinyint = null output,
  @MINSEQUENCE tinyint = null output,
  @TOTALLENGTH int = null output,
  @ISHISTORICAL bit = null output,
  @SITE nvarchar(250) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @NAME = [MKTSOURCECODE].[NAME],
    @DESCRIPTION = [MKTSOURCECODE].[DESCRIPTION],
    @SAMPLE = dbo.[UFN_MKTSOURCECODE_BUILDSAMPLECODE](@ID, 0),
    @ISACTIVE = [MKTSOURCECODE].[ISACTIVE],
    @ISDEFAULT = [MKTSOURCECODE].[ISDEFAULT],
    @INUSE = dbo.[UFN_MKTSOURCECODE_INUSE](@ID),
    @MAXSEQUENCE = (select max([SEQUENCE]) from dbo.[MKTSOURCECODEITEM] where [SOURCECODEID] = @ID),
    @MINSEQUENCE = (select min([SEQUENCE]) from dbo.[MKTSOURCECODEITEM] where [SOURCECODEID] = @ID),
    @TOTALLENGTH = dbo.[UFN_MKTSOURCECODE_GETLENGTH](@ID),
    @ISHISTORICAL = [MKTSOURCECODE].[ISHISTORICAL],
    @SITE = isnull((select [NAME] from dbo.[SITE] where [ID] = [MKTSOURCECODE].[SITEID]), '')
  from dbo.[MKTSOURCECODE]
  where [MKTSOURCECODE].[ID] = @ID;

  return 0;