USP_DATAFORMTEMPLATE_EDIT_DOCUMENT

The save procedure used by the edit dataform template "Document Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@REPORTCATALOGID	uniqueidentifier	IN	Report
@PRINTERLISTID	uniqueidentifier	IN	Printer list

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DOCUMENT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @REPORTCATALOGID uniqueidentifier,
    @PRINTERLISTID uniqueidentifier
)
as
begin
    declare @TYPECODE tinyint,
            @SVGFILENAME nvarchar(255),
            @SVGFILE varchar(max),
            @SVGFILECHANGED bit;

    exec USP_DATAFORMTEMPLATE_EDITLOAD_DOCUMENT
        @ID = @ID,
        @TYPECODE = @TYPECODE output,
        @SVGFILENAME = @SVGFILENAME output,
        @SVGFILE = @SVGFILE output,
        @SVGFILECHANGED = @SVGFILECHANGED output;

    exec USP_DATAFORMTEMPLATE_EDIT_DOCUMENT_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @REPORTCATALOGID,
        @PRINTERLISTID,
        @TYPECODE,
        @SVGFILENAME,
        @SVGFILE,
        @SVGFILECHANGED;

    return 0;

end