Configure Deleting Records

By Xelence Documentation posted 09-02-2021 10:23

Introduction

If you want users to be able to delete a row from a database table, you must set delete properties for the child objects.

Prerequisites

The child objects must be present before adding them to the configure delete order list.

	Quick Steps
1	Search for and open the entity
2	Open the Delete section
3	Click the + icon to add a new child object to the delete order list
4	Enter the child object details, then click OK
5	Save the entity
6	Open the lookup form
7	Open the results data table properties
8	Update the properties
9	Save the form

Detailed Steps

Step 1. Search for and open the entity.

This example uses entCustomer.

Step 2. Open the Delete section.

This is where you configure deleting objects from the application.

Step 3. Click the + icon to add a new child object to the delete order list.

You can add any number of child objects associated with that particular entity. Add the objects in the order you would like the application to delete them.

Step 4. Enter the child object details, then click OK.

The important properties are:

ID: Programmatic ID of the object.
Foreign Key: If you use a Foreign Key, the application will load the collection by executing a query with the foreign key.

Xelence adds the object to the list.

Step 5. Save the entity.

Step 6. Open the lookup form.

This example uses wfmCustomerLookup.

Step 7. Open the results data table properties.

You're going to update the results data table on the lookup form so users can delete records from it.

Step 8. Update the properties.

In the General section, make sure the Selection property is set to Many, so the user can select more than one row when deleting records.

In the General tab, make sure the Selection property is set to Many.

Step 9. Save the form.

Then, run the Preview. Xelence displays the form output. You can test your updated settings.

When you have previewed your form, it should look something like this. When you select one or more records and click the Delete button, the application will display a confirmation window, then delete the records and display a message.