USP_DATAFORMTEMPLATE_VIEW_MKTEXPORTDEFINITION

The load procedure used by the view dataform template "Marketing Export Definition 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.
@PREVIEWDATALISTCATALOGID	uniqueidentifier	INOUT	Preview data list catalog ID
@NETCOMMUNITYDATASOURCEID	int	INOUT	Blackbaud Internet Solutions data source ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTEXPORTDEFINITION]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @PREVIEWDATALISTCATALOGID uniqueidentifier = null output,
  @NETCOMMUNITYDATASOURCEID integer = null output
)
as
  begin
    set nocount on;

    select
      @DATALOADED = 1,
      @PREVIEWDATALISTCATALOGID = [PREVIEWDATALISTCATALOGID],
      @NETCOMMUNITYDATASOURCEID = [NETCOMMUNITYDATASOURCEID]
    from dbo.[MKTEXPORTDEFINITION]
    where [EXPORTDEFINITIONID] = @ID;

    if @DATALOADED = 0
      begin
        set @DATALOADED = 1;
        set @PREVIEWDATALISTCATALOGID = null;
        set @NETCOMMUNITYDATASOURCEID = 0;
      end

    return 0;
  end