How to Perform DML operations on Business Object in VBCS

In last section, we have seen introduction to Business objects and seen how to create business objects and display data from business object on VBCS page.

In this section, we will see how to perform DML (INSERT/UPDATE/DELETE) operations on business objects by creating page.

Let us consider page which we have created in last section as:

1. Create Page:
   

Let us create page to insert data into business objects.

Navigate to Quick Start section of table region as shown below:

Click on “Add Create Page”.

Let us drag and drop fields as shown above and then click on Finish.

This will automatically create “Create EmployeeBO” button. It will also create Event Listener and Action chain as show below:

Now let us run this page and insert data from UI.

Click on “Create EmployeeBO” to add new record.

Click on Save.

Here we can see new record is inserted.

1. Edit Page:
   

Let us create page to edit data into business objects

Navigate to Quick Start section of table region as shown below:

Drag and drop fields which we want to edit.

Click on finish.

Now run this application.

Select row and click on Edit EmployeeBO button to edit details for that row.

Change salary from 5000 to 10,000 and click on save.

1. Detail Page:
   

Let us create detail for business objects

Navigate to Quick Start section of table region as shown below:

Drag and drop fields which you want to display.

Click on Finish.

Run this application.

Select required row and click on EmployeeBO Details button.

Click on Back button to navigate to parent page.

1. Delete Page:
   

Let us create delete page to delete record from business objects

Navigate to Quick Start section of table region as shown below:

Select here business object and then click on Finish.

Here Delete EmployeeBO button is created.

Let us run this application.

Select row and click on Delete EmployeeBO button.

The selected record is deleted successfully.

Each action which we have performed earlier created separate page as:

Below action chains are created:

Below Event listeners are created as: