USP_DATAFORMTEMPLATE_ADD_WORKFLOW_INSTANCE_LOG
The save procedure used by the add dataform template "Workflow Instance Log Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @BBWORKFLOWINSTANCEINFOID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @LOGTYPECODE | tinyint | IN | Log type |
| @LOGMESSAGE | nvarchar(2048) | IN | Log message |
| @SOURCECODE | tinyint | IN | Source |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WORKFLOW_INSTANCE_LOG
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@BBWORKFLOWINSTANCEINFOID uniqueidentifier,
@LOGTYPECODE tinyint = 0,
@LOGMESSAGE nvarchar(2048) = '',
@SOURCECODE tinyint = 0
as
set nocount on;
if @ID is null
set @ID = newid();
declare @r int;
begin try
exec @r = dbo.USP_BBWORKFLOW_ADD_LOG_MESSAGE @ID,@CHANGEAGENTID,@BBWORKFLOWINSTANCEINFOID,@LOGTYPECODE,@LOGMESSAGE, @SOURCECODE;
return @r;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;