topic Re: qestion when UPDATE database table. in Application Development and Automation Discussions

qestion when UPDATE database table.

Former Member — Thu, 22 May 2008 15:04:25 GMT

hi gurus，

when i use UPDATE statement to update one record to database. how can i know it's seccessful and, if update error for table locking, how to roll back?

If this table is locking, how to release this locking?

thanks!

Re: qestion when UPDATE database table.

Former Member — Thu, 22 May 2008 15:25:04 GMT

After table update check sy-subrc variable.

sy-subrc Meaning

0 At least one line has been changed.

4 At least one line was not able to be changed, either because no appropriate line was found, or because the change would generate a line that leads to double entries in the primary key or a unique secondary index in the database table.

The statement UPDATE sets sy-dbcnt to the number of changed lines.

This information is avalaible in sap help (write update and press F1).

Locked table can be released in transaction sm12.

Regards

Re: qestion when UPDATE database table.

Former Member — Thu, 22 May 2008 15:32:17 GMT

Edited by: Sergi Marin on May 22, 2008 5:32 PM

Re: qestion when UPDATE database table.

Former Member — Thu, 22 May 2008 17:06:36 GMT

hi,

use commit work to save data if update was success (sy-subrc = 0), else rollback work( sy-subrc <> 0).

UPDATE <dbtab>.

if sy-subrc = 0.

COMMIT WORK.

else.

ROLLBACK WORK.

endif.

regards,

madhu

Re: qestion when UPDATE database table.

Former Member — Fri, 23 May 2008 04:20:34 GMT

Hi,

If SY-SUBRC = 0, the update is successful.

Shruthi

Re: qestion when UPDATE database table.

Former Member — Tue, 27 May 2008 08:41:50 GMT

u can try in the following

update < dbt>

if sy-subrc = 0.

commit work.

message' update succesful' type

elsif sy-subrc ne 0.

rollback.

message' update not succesful' type 'i'.

endif.

afte the execution of the program

if it is not updates in the DB then the information message will be shown similarly u can give message for succesful updation in between the condition.

rewards if useful

thanks

sachhidananda

Re: qestion when UPDATE database table.

Former Member — Wed, 28 May 2008 09:26:44 GMT

UPDATE RECORD TO DBTABLE

IF SY-SUBRC <> 0

ROLL BACK .

ENDIF .

U CAN UNLOCK THE LOCKED RECORD USING TCODE : SM12 .

REWARD IF USEFUL