USP_SMARTFIELD_DELETE

Executes the "Smart Field: Delete" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy


CREATE procedure dbo.USP_SMARTFIELD_DELETE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

  begin try
    exec dbo.USP_SMARTFIELD_VALIDATESMARTFIELDDELETE @ID;
    exec dbo.USP_SMARTFIELD_DELETESMARTFIELD @ID, @CHANGEAGENTID;
    return 0;
  end try

  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch