USP_DATAFORMTEMPLATE_EDITLOAD_MKTCONSTITUENTFILEIMPORT

The load procedure used by the edit dataform template "Segmented House File Import Process Edit"

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.
@SEGMENTATIONID	uniqueidentifier	INOUT	Marketing effort
@RECORDSOURCEHIDDEN	bit	INOUT	Record source hidden
@RECORDSOURCEID	uniqueidentifier	INOUT	Record source
@CATEGORY	uniqueidentifier	INOUT	Category
@FILENAME	nvarchar(255)	INOUT	File name
@QUANTITY	bigint	INOUT	Quantity
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTCONSTITUENTFILEIMPORT]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTATIONID uniqueidentifier = null output,
  @RECORDSOURCEHIDDEN bit = null output,
  @RECORDSOURCEID uniqueidentifier = null output,
  @CATEGORY uniqueidentifier = null output,
  @FILENAME nvarchar(255) = null output,
  @QUANTITY bigint = null output,
  @TSLONG bigint = 0 output
)
as
  set nocount on;

  set @DATALOADED = 0;

  declare @RECORDSOURCES table (
    [RECORDSOURCEID] uniqueidentifier,
    [RECORDSOURCEHIDDEN] bit,
    [CONSTITUENTRECORDTYPEID] uniqueidentifier)

  insert into @RECORDSOURCES
    exec dbo.[USP_MKTCONSTITUENTFILEIMPORT_ADD_LOAD]

  select
    @RECORDSOURCEID = RECORDSOURCEID,
    @RECORDSOURCEHIDDEN = RECORDSOURCEHIDDEN
  from @RECORDSOURCES;

  select
    @DATALOADED = 1,
    @SEGMENTATIONID = [SEGMENTATIONID],
    @CATEGORY = [CATEGORYCODEID],
    @FILENAME = [FILENAME],
    @QUANTITY = [QUANTITY],
    @TSLONG = [TSLONG] 
  from dbo.[MKTCONSTITUENTFILEIMPORTPROCESS]
  where [ID] = @ID;

  return 0;