Select statement is fetching previous data

[Former Member]

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.

[former_member188724]

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

[paul_bakker2]

Hi,

Did you do a 'commit work' after updating?

cheers

Paul B

[yogendra_bhaskar]

Hi Satya ,

Use commit work after modifying the ztable.

Regards

Yogendra Bhaskar

[Former Member]

Hi

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

Hi,

Thanks for your time and inputs.

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

Thanks,

Phani.

[paul_bakker2]

Great! Please close the thread.

cheers

Paul