How to Update a record using Update command , difference between update and doupdate methods.

UPDATE


ttsbegin;

select forupdate table15
          where table15.Acno  =  "345";

table15.Amt = 555;
table15.Update( );

ttscommit;


ttsbegin & ttscommit are used for one record to insert/update/delete.

doUpdate

If a update method is overriden at the object level then at the time of update command execution then the value given in the update method is executed.

And if u want to update the value which was given in the update command at any cost then we use doinsert( ) so that the values are not validated and inserts the value to database.

ttsbegin;

select forupdate table15
          where table15.Acno  == 345;

table15.Amt = 555;
table15.doUpdate( );

ttscommit;