USP_DATAFORMINSTANCE_UPDATEFORMDEF_SP
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @FORMDEFXML | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure [dbo].[USP_DATAFORMINSTANCE_UPDATEFORMDEF_SP]
@ID uniqueidentifier,
@FORMDEFXML xml,
@CHANGEAGENTID uniqueidentifier = null
as
set nocount on
if @CHANGEAGENTID is null exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
update dbo.DATAFORMINSTANCECATALOG
set FORMUIXML = @FORMDEFXML,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where ID = @ID
if @@error <> 0 return 1
exec USP_DATAFORMINSTANCE_CREATEORUPDATEPROCEDURES @ID
if @@error <> 0 return 2
return 0;