USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMDONATION_PRELOAD

The load procedure used by the edit dataform template "Order Donation Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@AMOUNT	money	INOUT	Amount
@DESIGNATIONID	uniqueidentifier	INOUT	Designation
@CONSTITUENTID	uniqueidentifier	INOUT	Patron

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SALESORDERITEMDONATION_PRELOAD
(
    @SALESORDERID uniqueidentifier,
    @AMOUNT money = null output,
    @DESIGNATIONID uniqueidentifier = null output,
    @CONSTITUENTID uniqueidentifier = null output
)
as
    set nocount on;

    select 
        @AMOUNT = AMOUNT,
        @DESIGNATIONID = DESIGNATIONID
    from dbo.DONATIONPOS

    select @CONSTITUENTID = CONSTITUENTID
    from dbo.SALESORDER
    where ID = @SALESORDERID;

    return 0;