USP_DATAFORMTEMPLATE_PRELOAD_ADD_PRICELISTCOPY

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@COPYFROM	nvarchar(100)	INOUT	Copy from
@PRICES	xml	INOUT	Prices

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PRICELISTCOPY
                (
                    @CONTEXTID uniqueidentifier,
                    @COPYFROM nvarchar(100) = null output,
                    @PRICES xml = null output
                )
                as
                set nocount on; 

                set @PRICES = dbo.UFN_PRICELIST_GETPRICES_TOITEMLISTXML(@CONTEXTID);
                select @COPYFROM = NAME from dbo.PRICELIST where ID = @CONTEXTID

                return 0;