BDC-Roll back

[Former Member]

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

Misha

[Former Member]

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............

[Former Member]

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

[Former Member]

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