topic Re: BDC-Roll back in Application Development and Automation Discussions

BDC-Roll back

Former Member — Mon, 17 Mar 2008 08:42:07 GMT

Can we rollback the changes in database by BDC call transaction (sychronous) method (using rollback statement)?

Misha

Re: BDC-Roll back

Former Member — Mon, 17 Mar 2008 08:45:40 GMT

no its not possible. Because the values updated by Call transaction will follow an automatic commit work.

hence once values get commit u cannot rollback.

Reward if useful............

Re: BDC-Roll back

Former Member — Mon, 17 Mar 2008 09:08:55 GMT

hi,

we cannot delete the data from the database once it has been uploaded through BDC not even by using rollback statement. If you want to delete the records from database then either you have to delete the records fom that table's view or you can write a piece of code to delete the required records.

Regards,

N.jain

Re: BDC-Roll back

Former Member — Mon, 17 Mar 2008 09:12:02 GMT

Hi Misha,

it is not possible in bdc but you can have one more option in indirectly

keep one check box in selection-screen,like test mode

when you click test mode then do not use save ok_code ( It works like Roll back )

if you use call transaction ,then if you use update mode is Synchronous ,it works like committ work.

Regards

Kiran Sure