USP_DATAFORMTEMPLATE_PRELOAD_ADD_PRICE

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRICELISTID	uniqueidentifier	INOUT	Price list

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PRICE
                (
                    @CONTEXTID uniqueidentifier,
                    @PRICELISTID uniqueidentifier = null output
                )
                as
                    set nocount on; 

                    if exists(select ID from dbo.PRICELIST where ID = @CONTEXTID and ISACTIVE = 1)
                        set @PRICELISTID = @CONTEXTID

                    return 0;