CascadeDelete

<< Click to Display Table of Contents >>

Navigation:  Administration and Configuration > ST_CONFIG Entries >

CascadeDelete

CascadeDelete.Enabled

CascadeDelete.Visible

 

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.

 

CascadeDelete.Enabled

 

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

 

 

CascadeDelete.Visible

 

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