USP_DATAFORMTEMPLATE_EDITLOAD_BBPAYTRANSACTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@SALESORDERID	uniqueidentifier	INOUT
@TRANSACTIONID	uniqueidentifier	INOUT
@TRANSACTIONAMOUNT	money	INOUT
@TRANSACTIONCONFIRMED	bit	INOUT
@CARDCHARGED	bit	INOUT
@PROCESSINGRESULTCODE	tinyint	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBPAYTRANSACTION(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @SALESORDERID uniqueidentifier = null output,
  @TRANSACTIONID uniqueidentifier = null output,
  @TRANSACTIONAMOUNT money  = null output,
  @TRANSACTIONCONFIRMED bit = null output,
  @CARDCHARGED bit = null output,
  @PROCESSINGRESULTCODE tinyint = null output
) as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @SALESORDERID = SALESORDERID,
        @TRANSACTIONID = TRANSACTIONID,
        @TRANSACTIONAMOUNT = TRANSACTIONAMOUNT,
        @TRANSACTIONCONFIRMED = TRANSACTIONCONFIRMED,
        @CARDCHARGED = CARDCHARGED,
        @PROCESSINGRESULTCODE = PROCESSINGRESULTCODE
    from dbo.SALESORDERBBPAYTRANSACTION
    where ID = @ID

    return 0;