USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTINSTANCE_PRELOAD

The load procedure used by the edit dataform template "Merchandise Item Instance Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@MERCHANDISEPRODUCTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@OPTIONCOUNT	int	INOUT	Option count
@PRODUCTOPTIONS	xml	INOUT	Options

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTINSTANCE_PRELOAD
                (
                    @MERCHANDISEPRODUCTID uniqueidentifier,
                    @OPTIONCOUNT integer = null output,
                    @PRODUCTOPTIONS xml = null output
                )
                as
                    set nocount on;

                select
                    @OPTIONCOUNT = count(*)
                from
                    dbo.MERCHANDISEPRODUCTOPTION
                where
                    MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID

                if @OPTIONCOUNT > 0
                begin
                    set @PRODUCTOPTIONS = dbo.UFN_MERCHANDISE_GETNEWPRODUCTINSTANCEOPTIONS_2_TOITEMLISTXML(@MERCHANDISEPRODUCTID)
                end

                    return 0;