USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTLABELPRINT_PRELOAD

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

Parameters

Parameter Parameter Type Mode Description
@MERCHANDISEPRODUCTID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@PRODUCTLABELS xml INOUT Labels to print

Definition

Copy

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MERCHANDISEPRODUCTLABELPRINT_PRELOAD
(    
    @MERCHANDISEPRODUCTID uniqueidentifier,
    @PRODUCTLABELS xml = null output
)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database
    set @PRODUCTLABELS = dbo.UFN_MERCHANDISE_GETPRODUCTLABELSTOPRINT_TOITEMLISTXML(@MERCHANDISEPRODUCTID)

    return 0;