USP_DATAFORMTEMPLATE_VIEW_MKTLETTERCODE

The load procedure used by the view dataform template "Letter 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.
@WORDFILE	varbinary	INOUT	File
@WORDTEMPLATEFILENAME	nvarchar(255)	INOUT	Filename
@EXPORTDEFINITION	nvarchar(100)	INOUT	Export definition
@EXPORTDEFINITIONID	uniqueidentifier	INOUT	Export definition ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTLETTERCODE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @WORDFILE varbinary(max) = null output,
  @WORDTEMPLATEFILENAME nvarchar(255) = null output,
  @EXPORTDEFINITION nvarchar(100) = null output,
  @EXPORTDEFINITIONID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @WORDFILE = [LETTERCODE].[WORDFILE],
    @WORDTEMPLATEFILENAME = [LETTERCODE].[WORDTEMPLATEFILENAME],
    @EXPORTDEFINITION = [EXPORTDEFINITION].[NAME],
    @EXPORTDEFINITIONID = [EXPORTDEFINITION].[ID]
  from dbo.[LETTERCODE]
  left outer join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]
  where [LETTERCODE].[ID] = @ID;

  return 0;