topic Re: Select statement is fetching previous data in Application Development and Automation Discussions

Select statement is fetching previous data

Former Member — Thu, 25 Sep 2014 15:13:06 GMT

Hi,

I am modifying records in a ztable through a program.

records were successfully modified in the ZTABLE.

through the same program i tried to fetch the data from the same ZTABLE

but its deriving the old records only, tough table is showing updated records.

with the doubt of whether still in the buffer, i used the RollBack statement also,

still i am getting the old table data only.

In table techincal settings

Buffering not allowed option was selected,

tough its deriving old table entries only.

Thanks,

Phani.

Re: Select statement is fetching previous data

former_member188724 — Thu, 25 Sep 2014 19:41:01 GMT

Hi,

You say its updated. Maybe you are not clearing the work area when you are fetching the data after updation.

Hope this helps you.

Regards,

K.S

Re: Select statement is fetching previous data

paul_bakker2 — Thu, 25 Sep 2014 23:20:13 GMT

Hi,

Did you do a 'commit work' after updating?

cheers

Paul B

Re: Select statement is fetching previous data

yogendra_bhaskar — Fri, 26 Sep 2014 04:41:31 GMT

Hi Satya ,

Use commit work after modifying the ztable.

Regards

Yogendra Bhaskar

Re: Select statement is fetching previous data

Former Member — Fri, 26 Sep 2014 08:05:48 GMT

Before select i already using refresh

and after update i am using commit work also,

Don't understand why its fetching previous data.

Thanks,

Phani

Re: Select statement is fetching previous data

Former Member — Fri, 26 Sep 2014 08:13:37 GMT

Hi Satya,

Check the conditions on basis of which you are selecting the records from Z table.

Might be the updated records in Z table not satisfying the conditions used to fetch the data.

Thanks & Regards,

Swati

Re: Select statement is fetching previous data

RaymondGiuseppi — Fri, 26 Sep 2014 08:31:19 GMT

Could you use FM DB_COMMIT (or statement COMMIT WORK, WAIT option not required here) and reload data using a BYPASSING BUFFER option in the SELECT statement.

If data is once again not refreshed, there the database manager has not yet committed in time data, so you may be required to use a FOR UPDATE option (BYPASSING BUFFER will be no longer required as it will be implicit) to insure that, but you will have to catch error (sy-subrc = 😎 and retry.

Regards,

Raymond

Re: Select statement is fetching previous data

Former Member — Fri, 26 Sep 2014 08:47:45 GMT

Hi,

Thanks for your time and inputs.

I did a small mistake, now i corrected its working fine.

Thanks,

Phani.

Re: Select statement is fetching previous data

paul_bakker2 — Fri, 26 Sep 2014 11:00:42 GMT

Great! Please close the thread.

cheers

Paul