topic Re: Update table in Application Development and Automation Discussions

Update table

Former Member — Mon, 18 Aug 2008 12:06:26 GMT

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?

Re: Update table

Former Member — Mon, 18 Aug 2008 12:07:51 GMT

Try to use WAIT Statement after your updation of records in table.

Thanks

Sudharshan

Re: Update table

Former Member — Mon, 18 Aug 2008 12:07:57 GMT

hi,

Write COMMIT WORK in your User Exit After the Updation Logic.

It will Perform Updation at that time.

Regards

Sumit Agarwal

Re: Update table

Former Member — Mon, 18 Aug 2008 12:35:13 GMT

Hi,

Commit work will solve your problem but use it with caution. As it is not recommended to be used in user exit.

Re: Update table

former_member217544 — Mon, 18 Aug 2008 12:42:58 GMT

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.