topic Re: Select statement issue in Application Development and Automation Discussions

Select statement issue

suganya_rangarajan — Fri, 26 Oct 2007 13:49:15 GMT

Hi,

I have a FM which will update the database table.The FM also does the commint.

After that when I try to do select query to the table,sy-subrc returns 0(succeeds) in debug mode but returns 2(fails) in real scenario i.e when i don't have breakpoints.

Any solution for the issue.

Thanks

Suganya

Re: Select statement issue

Former Member — Fri, 26 Oct 2007 14:05:32 GMT

The V1 update process has probably not completed. When you do the COMMIT, do a COMMIT WORK AND WAIT.

Rob

Re: Select statement issue

Former Member — Fri, 26 Oct 2007 14:06:27 GMT

Hi,

When u are in debug mode , commit work will be executed by system. so u can select the data immediately after update.

but when u execute normally commit will be executed when the transaction ends, so it cant fetch immediately after update.

after update try BAPI_TRANSACTION_COMMIT

exporting wait = 'X'.

this will work

Re: Select statement issue

Former Member — Fri, 26 Oct 2007 14:07:13 GMT

Suganya,

Explicitly write a commit work statement after Function module.

<b> Reward for helpful answers</b>

Satish

Re: Select statement issue

Former Member — Fri, 26 Oct 2007 14:17:59 GMT

As Rob suggested, add AND WAIT to the commit statement. Also check your table and see if it is buffered (technical settings). If it is buffered, you can add BYPASSING BUFFER to your SELECT statement.

Re: Select statement issue

SAPAI — Fri, 26 Oct 2007 14:24:30 GMT

please use commit work and wait.

actually you need to wait for the commit work to get completed and database updation.

you can put explicit wait also but not recommended.