USP_EXPORTDEFINITION_UPDATEVIEWDATAFORMTEMPLATEID

Updates export definition with the related view data form template ID.

Parameters

Parameter	Parameter Type	Mode
@EXPORTDEFINITIONID	uniqueidentifier	IN
@VIEWDATAFORMTEMPLATEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_EXPORTDEFINITION_UPDATEVIEWDATAFORMTEMPLATEID
(
  @EXPORTDEFINITIONID uniqueidentifier,
  @VIEWDATAFORMTEMPLATEID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)

as
begin
    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    update dbo.[EXPORTDEFINITION] set
        [VIEWDATAFORMTEMPLATEID] = @VIEWDATAFORMTEMPLATEID,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE
    where [ID] = @EXPORTDEFINITIONID;

    return 0;
end