USP_DATAFORMTEMPLATE_EDIT_PAGE_MODEL_DESIGN_2

The save procedure used by the edit dataform template "Page Model Design Edit 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.
@MODELNAME	nvarchar(256)	IN	Modelname
@CLIENTSITESID	int	IN	Clientsites
@ARTIFACTPREFIX	nvarchar(256)	IN	ArtifactPrefix
@LOCKARTIFACTS	bit	IN	Lockartifacts
@MODELID	uniqueidentifier	IN	Modelid
@EXPORTOPTIONS	nvarchar(max)	IN	Export options

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAGE_MODEL_DESIGN_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @MODELNAME nvarchar(256),
  @CLIENTSITESID INTEGER,
  @ARTIFACTPREFIX nvarchar(256),
  @LOCKARTIFACTS bit,
  @MODELID uniqueidentifier,
  @EXPORTOPTIONS nvarchar(max)
)
as

  set nocount on;

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

  begin try
    -- handle updating the data

    update dbo.PAGEMODELDESIGN set
      MODELNAME = @MODELNAME,
      CLIENTSITESID = @CLIENTSITESID,
      ARTIFACTPREFIX=@ARTIFACTPREFIX,
      LOCKARTIFACTS = @LOCKARTIFACTS,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = getdate(),
      MODELID = @MODELID,
      EXPORTOPTIONS = @EXPORTOPTIONS
    where ID = @ID
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

return 0;