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.
- 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.
Example: You would not be able to delete an individual who has an invoice because that would violate a foreign key constraint.
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.