<< Click to Display Table of Contents >> Navigation: Configuration > ST_CONFIG Entries > CascadeDelete |
The CascadeDelete settings control whether the Cascade Delete button for a table is visible and/or enabled for a user in EQuIS Professional. It will not override Permissions that would otherwise prevent access to the Cascade Delete functionality in EQuIS Professional, nor will it if the table is a restricted table. However, ALS users who are not connected as a member of the database DB_OWNER role may need this setting to access the button.
EQuIS Version: v6.0+
Namespace: EarthSoft.EDP
Products Affected: Professional
Required Modules: Professional
ST_CONFIG |
VALUE |
REMARK |
VALID VALUES |
---|---|---|---|
CONFIG_SECTION |
CascadeDelete |
Required |
|
CONFIG_KEY |
Enabled |
Required |
|
OBJECT_TYPE |
null |
||
OBJECT_VALUE |
null |
||
STRING_VALUE |
<string> |
Choose one |
Everyone OnlyDatabaseOwner |
Options
Everyone – If not otherwise restricted due to permissions or if the table is a restricted table, this enables the button for all users, whether the user is connected to the database as a member of the DB_OWNER role or not.
Note 1: The button could be separately set to not be visible with the CascadeDelete.Visible setting, which will effectively prevent use of the button.
Note 2: The connection to the database will still require database delete permissions on that table or the Cascade Delete action will fail.
OnlyDatabaseOwner – The default functionality. For the button to be enabled, even if the user has permission on the form, the user must be connected to the database as a member of the DB_OWNER database role.
Example
CONFIG_SECTION |
CONFIG_KEY |
OBJECT_TYPE |
OBJECT_VALUE |
STRING_VALUE |
---|---|---|---|---|
CascadeDelete |
Enabled |
Everyone |
ST_CONFIG |
VALUE |
REMARK |
VALID VALUES |
---|---|---|---|
CONFIG_SECTION |
CascadeDelete |
Required |
|
CONFIG_KEY |
Visible |
Required |
|
OBJECT_TYPE |
null |
||
OBJECT_VALUE |
null |
||
STRING_VALUE |
Choose One |
True False IfEnabled |
Options
True – The default functionality. If not otherwise restricted due to permissions or if the table is a restricted table, this displays the button for all users.
False – The Cascade Delete button will not be visible to any user.
IfEnabled – If not otherwise restricted due to permissions or if the table is a restricted table, the Cascade Delete button will only be visible if it is also enabled as set by the CascadeDelete.Enabled property.
Example:
CONFIG_SECTION |
CONFIG_KEY |
OBJECT_TYPE |
OBJECT_VALUE |
STRING_VALUE |
---|---|---|---|---|
CascadeDelete |
Visible |
IfEnabled |
Copyright © 2023 EarthSoft, Inc • Modified: 26 Sep 2022