Creating, Updating, and Deleting MBO Records with Sybase Unwired Platform in Android

Perform create, update, and delete operations on the MBO instances that you have created.

You can call the create, update, and delete methods for MBO instances.

Note: For MBOs with custom create or update operations with parameters, you should use the custom operations, rather than the default create and update operations. See MBOs with Complex Types.

1. Suppose you have an MBO named Customer. To create an instance within the database, invoke its create method, which causes the object to enter a pending state. Then call the MBO instance's submitPending method. Finally, synchronize with the generated database:

   Customer newcustomer = new Customer();
   //Set the required fields for the customer
   // …
   
   newcustomer.create();
   newcustomer.submitPending();
   SUP101DB.synchronize();

   For DOE-based applications, omit SUP101DB.synchronize; above.
2. To update an existing MBO instance, retrieve the object instance through a query, update its attributes, and invoke its update method, which causes the object to enter a pending state. Then call the MBO instance's submitPending method. Finally, synchronize with the generated database:

   Customer customer = Customer.findByPrimaryKey(myCustomerId); //find by primary key
   customer.setCity("Dublin"); //update any field to a new value
   customer.update();
   customer.submitPending();
   SUP101DB.synchronize(); 
   

   For DOE-based applications, omit SUP101DB.synchronize; above.
3. To delete an existing MBO instance, retrieve the object instance through a query and invoke its delete method, which causes the object to enter a pending state. Then call the MBO instance's submitPending method. Finally, synchronize with the generated database:

   Customer customer = Customer.findByPrimaryKey(myCustomerId); //find by primary key
   customer.delete();
   customer.submitPending();
   SUP101DB.synchronize();

   For DOE-based applications, omit SUP101DB.synchronize; above.