topic Re: commit/rollback in Application Development and Automation Discussions

commit/rollback

Former Member — Tue, 05 Dec 2006 05:24:59 GMT

There is a record having many fields & I want to insert the record in 3 custom tables designed accordingly . but either all the tables should get filled or none of the table should get filled.Should I use commit/rollback?? How??

The following is the syntax in a function module.

INSERT ZTEST1 FROM ZTEST1.

INSERT ZTEST2 FROM ZTEST2.

INSERT ZTEST3 FROM ZTEST3.

IF SY-SUBRC = 0.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

This does not work. Any Solution??

Re: commit/rollback

Sandeep_Panghal — Tue, 05 Dec 2006 05:30:54 GMT

Hi,

If u want to check all the tables :

Try this:

INSERT ZTEST1 FROM ZTEST1.

IF SY-SUBRC = 0.

INSERT ZTEST2 FROM ZTEST2.

IF SY-SUBRC = 0.

INSERT ZTEST3 FROM ZTEST3.

IF SY-SUBRC = 0.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

endif.

So u can check the commit work for all the three .

Hope this helps.

Re: commit/rollback

Former Member — Tue, 05 Dec 2006 05:32:34 GMT

the code you are writte will check only third insert.

do in the following way

form save_data.

INSERT ZTEST1 FROM ZTEST1.

if sy-subrc = 0

INSERT ZTEST2 FROM ZTEST2.

if sy-subrc = 0

INSERT ZTEST3 FROM ZTEST3.

else.

rollback work

exit.

endif.

else.

rollback work

exit.

endif..

commit work.

endform.

Message was edited by:

SHEFALI GANGRADE

Re: commit/rollback

Former Member — Tue, 05 Dec 2006 06:49:36 GMT

Hi Deepali,

1. Never ever use a insert to pdate any table , always use a function module in

update mode, this is the best industry practise.

2. Use all the three insert statements insde a custom function module in

update mode, this will udate all if sucess and roll back if any one fails.

Regards,

Vaibhav B Gawali.

Re: commit/rollback

Former Member — Tue, 05 Dec 2006 07:00:28 GMT

Hi,

The following code will helps to you.

INSERT ZTEST1 FROM ZTEST1.
if sy-subrc ne 0.
rollback work.
exit.
endif. 

INSERT ZTEST2 FROM ZTEST2.
if sy-subrc ne 0.
rollback work.
exit.
endif. 

INSERT ZTEST3 FROM ZTEST3.
if sy-subrc ne 0.
rollback work.
exit.
endif. 

commit work.

Regards

Bhupal Reddy