USP_DATAFORMTEMPLATE_VIEW_MKTSOURCECODEPARTDEFINITIONVALUES

The load procedure used by the view dataform template "Source Code Part Definition Values View"

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.
@SOURCECODEVALUES	xml	INOUT	Source code values

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSOURCECODEPARTDEFINITIONVALUES]
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @SOURCECODEVALUES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    set @SOURCECODEVALUES = (
      select
      newID() as [ID],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] as [MKTSOURCECODEPARTDEFINITIONVALUESID],
      0 as [SELECTED],
        [MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION],
        [MKTSOURCECODEPARTDEFINITIONVALUES].[FORMAT]
      from dbo.[MKTSOURCECODEPARTDEFINITIONVALUES]
      where [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID] = @ID
      for xml raw('ITEM'),type,elements,root('SOURCECODEVALUES'),BINARY BASE64
  );

  if not(@SOURCECODEVALUES is null)
      set @DATALOADED = 1;

    return 0;