USP_DATAFORM_REMOVEFIELDCHARACTERISTICS
Remove the characteristics for a field on a data form.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATAFORMINSTANCEID | uniqueidentifier | IN | |
| @FIELDID | nvarchar(200) | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_DATAFORM_REMOVEFIELDCHARACTERISTICS
(
@DATAFORMINSTANCEID uniqueidentifier,
@FIELDID nvarchar(200),
@CHANGEAGENTID uniqueidentifier
)
as
begin
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @ID as uniqueidentifier;
select @ID = ID
from dbo.DATAFORMFIELDCHARACTERISTIC
where DATAFORMINSTANCEID = @DATAFORMINSTANCEID and FIELDID = @FIELDID;
exec dbo.USP_DATAFORMFIELDCHARACTERISTIC_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
return 0;
end