DeleteMethod

Initial Build

2006.01 or earlier

Module

Admin

Current Setting Type

Drop-down List

Use the DeleteMethod system option to select the method that the netFORUM uses to delete a record when an iWeb user clicks the Delete button on a form.

Current Setting

The current setting for SystemOptionName is used as follows:

Values: This system option can be set to hard or soft.

  • hard—Remove the record from the database unless a foreign key constraint would be violated.
  • Example: You would not be able to delete an individual who has an invoice because that would violate a foreign key constraint.

  • soft—Leave the record in the database, but set the record's delete flag field to 1. A soft-deleted record is not available in the netFORUM interface, but it can be recovered.

Default Value: hard

Customers might want to use the soft delete method if they want to make sure data is never lost. A soft-deleted record can be recovered.

Customers who assume that all users have valid reasons to delete a record might want to use the hard delete method to avoid cluttering the database with unnecessary records. Most edit forms have a hide/disable option so that data records can be soft-deleted even when the delete method at the system level is set to hard.

Note: The majority of hosted netFORUM customers use the hard delete method.

Fields 

This system option includes the following fields:

description: This field gives the description of the system option, including its use and default value.

Important! Do not modify the following fields after the system option is first created. Changing these fields after they have been used can invalidate existing data.

category: This field sets the category (usually the module) where the system option is used.

type : The type field determines the display type of the current setting field (check box, drop-down list, or text box).

values: The values field indicates the allowed values for the current setting field.

Availability

Each system option includes the following availability settings:

entity level option?: Select this check box to make this system option available on an entity level.

visible to external systems?: Select this check box to make this system option available in xWeb.