USP_DATAFORMTEMPLATE_EDITLOAD_MKTFINDERNUMBER

The load procedure used by the edit dataform template "Finder Number Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@FIXEDWIDTH	tinyint	INOUT	Fixed width
@FINDERNUMBER	bigint	INOUT	Next finder number
@NEXTMAILINGFINDERNUMBER	bigint	INOUT	Next marketing effort finder number
@CHECKDIGIT	bit	INOUT	Check digit
@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_MKTFINDERNUMBER]
(
  @DATALOADED bit = 0 output,
  @FIXEDWIDTH tinyint = null output,
  @FINDERNUMBER bigint = null output,
  @NEXTMAILINGFINDERNUMBER bigint = null output,
  @CHECKDIGIT bit = null output,
  @TSLONG bigint = 0 output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @FIXEDWIDTH = [MKTFINDERNUMBER].[FIXEDWIDTH],
    @FINDERNUMBER = [FINDERNUMBER], 
    @NEXTMAILINGFINDERNUMBER = (select isnull(max([MKTSEGMENTATIONFINDERNUMBER].[MAX]), 0) + 1 from dbo.[MKTSEGMENTATIONFINDERNUMBER]),        
    @CHECKDIGIT = [MKTFINDERNUMBER].[CHECKDIGIT],
    @TSLONG = [MKTFINDERNUMBER].[TSLONG]
  from
    dbo.[MKTFINDERNUMBER];

  return 0;