‎2008 Aug 18 1:06 PM
Guys,
I am doing an update on a dbase table in a user exit. After updating the table I am calling the table in my main program by calling the PBO of the main screen.
But i observed that the table updation is happening only after a while, as a result the old values are retrieved when I reload the screen. Is there any way I can ensure that the table gets updated before my screen call?
‎2008 Aug 18 1:07 PM
hi,
Write COMMIT WORK in your User Exit After the Updation Logic.
It will Perform Updation at that time.
Regards
Sumit Agarwal
‎2008 Aug 18 1:07 PM
Try to use WAIT Statement after your updation of records in table.
Thanks
Sudharshan
‎2008 Aug 18 1:07 PM
hi,
Write COMMIT WORK in your User Exit After the Updation Logic.
It will Perform Updation at that time.
Regards
Sumit Agarwal
‎2008 Aug 18 1:35 PM
Hi,
Commit work will solve your problem but use it with caution. As it is not recommended to be used in user exit.
‎2008 Aug 18 1:42 PM
Hi,
COMMIT statement will resolve the issue else you can use the following BAPI.
CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
WAIT = 'X'
IMPORTING
RETURN = RETURN.
Return will show the success or failure of the commit statement.
If that is still not getting updated then try using the WAIT statement separately.
WAIT UP TO 2 SECONDS.
Hope this will solve the issue.
Regards,
Swarna Munukoti.