Update and commit

Hi,

  Can someone help me with my concern, we have a query which contains the following command below. based on the code it will first insert data into the table then it will update the data status and lastly it will be commited.

   I have checked the data in backend, after Inserting the data the update command was not applied. But here is the catch the commit command take effects.

   Insert 

   Update

   Commit

Kindly advise regarding my concern.

Thanks