topic Re: Check if database table update finished. in Application Development and Automation Discussions

Check if database table update finished.

Former Member — Wed, 29 Aug 2007 06:21:33 GMT

Hello my dear friends,

In my program,I submit a standard SAP program that inserts a few records to a database table. After the program ends I need to select these records, but I do not know if their insertion finished.

If you know of a way to solve this problem please help me, its very urgent.

Regards,

Eitan Iluzz.

Re: Check if database table update finished.

Former Member — Wed, 29 Aug 2007 06:25:20 GMT

u can check sy-dbcnt system variable value it shows no of hits to the database.

Regards

sandhya

Re: Check if database table update finished.

Former Member — Wed, 29 Aug 2007 06:26:59 GMT

Hi,

check sy-subrc value in ur program.

if sy-subrc = 0.

endif.

<b>reward if helpful</b>

rgds,

bharat.

Re: Check if database table update finished.

Former Member — Wed, 29 Aug 2007 06:27:10 GMT

Hi,

After Update statement keep sy-subrc check. if it zero then values are updated in database.

Reward points.if helpful

Bohra

Re: Check if database table update finished.

Former Member — Wed, 29 Aug 2007 06:32:53 GMT

Hello Eli Eren,

There is a system variable called sy-subrc, which return return code for the abap statements.

If any statement executed successfully... it will return 0, otherwise not...

just check for sy-subrc value after your update database statement.

if it is 0 then, updated successflly, other wise not.

Reward If Useful.

Regards

Sasidhar Reddy Matli.