USP_DATAFORMTEMPLATE_VIEW_BATCHANONYMOUSPAYMENT

The load procedure used by the view dataform template "Batch Anonymous Payment 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.
@GIVENANONYMOUSLY bit INOUT GIVENANONYMOUSLY

Definition

Copy


    create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_BATCHANONYMOUSPAYMENT
    (
      @ID uniqueidentifier,
      @DATALOADED bit = 0 output,
      @GIVENANONYMOUSLY bit = null output
    )
    as
      set nocount on;

      select 
        @DATALOADED = 1,
        @GIVENANONYMOUSLY = GIVENANONYMOUSLY 
      from dbo.REVENUE
      where REVENUE.ID = @ID