AR_FIELD_FORCE_DELETE is Input Argument to ARDeleteField Function so if you want to use this then you have to write a C code and in this include arextern.h so you will be able to use this API functions.
Then use that API program in Run Process Action of Filter or Escalation or you can Directly execute this program from command line.
Required parameters for ARDeleteField Function are as below
The control record for the operation. It contains information about the user
requesting the operation, where that operation is to be performed, and which
session is used to perform it. The user and server fields are required.
If a valid overlay group is specified in the control record, the ARDelete* function
operates on the object that belongs to that group. If no group is specified, the
function operates on the origin object. To specify whether to use an object’s real or
resolved name in an operation and whether to perform the operation only on
objects in a specified overlay group, use the
AR_SESS_CONTROL_PROP_DESIGN_OVERLAYGROUP variable of the
The name of the form containing the field to delete.
The internal ID of the field to delete.
A value that indicates the action to take if the specified field contains data
(applicable only to base forms) or is associated with a join form.
0: Do not delete the field (AR_FIELD_CLEAN_DELETE).
1: Delete if the field contains data but not if it is associated with a join
2: Delete the field, all join form fields that map to it, and all join forms
dependent on it for join qualification (AR_FIELD_FORCE_DELETE).
For complete reference please see C API Reference Guide.
Please be sure to mark Correct or Helpful answer on quick response if you find my inputs useful
Thanks for quick response. I will let you know if this works.
This makes no sense. The error you are describing is typically found when you are trying to delete a field on a regular form that is utilized in a join. In those situations, you must first delete the field from the join before you delete it from the parent form...but you should NOT be getting this when modifying a display only form.
The field ID in question, what type of field on your display only form is it?
It should NOT show this error, but it does with display only form and even this field does not exists on Display only form.
I would recommend turning on SQL Logging and see what is happening at the time of the save, it should give you some insight that may be usefull
What info you think SQL logs will provide for changes in Dev studio?
I checked the API logs but didn't find anything useful.
I'm hoping that it'll provide some sort of delete statement that would include the field id in question...I'm not really sure...but I have found the SQL logs to be helpful in situations like this to try and figure out what Dev Studio is trying to do.
Anyone, is there an "easy option to show relations like this?
I have the same error and I'm willing to deelte the field in the related forms if I could find out in which one it is to be found...
I think the field in question was hidden on the related form in stead of removed.
I faced similar issue recently in CMDB. I had to find out all the child forms, delete that field from child form first and then from parent. Need to take step by step approach to resolve this error.