topic Re: UPDATE statement not working , please help in Application Development and Automation Discussions

UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 19:37:34 GMT

Hello Guys,

Please see the below code and its not working. please help if thers is any bug.

UPDATE table

SET field1 = 'X'

WHERE condition.

Thanks in advance,

Angelo

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 19:39:13 GMT

It would help to know the condition and table used.

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 20:00:55 GMT

alright, here is the complete code.

LOOP AT itab INTO work_area.

UPDATE Ztable

SET field1 = 'X'

WHERE field2 = work_area-field2.

ENDLOOP.

Thank guys,

Angelo

Edited by: SAPBW2010 on May 11, 2010 10:01 PM

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 20:06:11 GMT

I must use the UPDATE statement inside LOOP.

Thanks

Angelo

Re: UPDATE statement not working , please help

vinod_vemuru2 — Tue, 11 May 2010 20:07:05 GMT

Hi,

Are you sure that you have a record in Ztable as per WHERE condition? What is the SY-SUBRC after update? If zero, add COMMIT WORK statement after update.

Thanks,

Vinod.

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 20:21:50 GMT

added COMMIT WORK but its not working.

Yes we have matching records.

Thanks

Angelo

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 20:29:22 GMT

If you really want help, don't say things like "it's not working". This gives no information. You have to say what is not working. Are you getting a dump? A return code? No changes?

And you haven't given you real source code. You also have to look at the WHERE to see if there really are any matches. Conversion exits may be confusing the issue as well.

Please do some analysis and let the forum know what the problem is.

Rob

Re: UPDATE statement not working , please help

vinod_vemuru2 — Tue, 11 May 2010 20:30:00 GMT

Hi,

There may be a possibility of having conversion exit for that field. If yes, you can convert and then use in update statement.

Check if the where clause field is case sensitive.

For testing purpose, can you write a select query on that table with the same WHERE condition just before the update statement and see if you have the data. I am sure that your select should also fail.

By the way, you didn't tell the sy-subrc value after the update statement.

Thanks,

Vinod.

Re: UPDATE statement not working , please help

Former Member — Tue, 11 May 2010 20:30:21 GMT

SY-SUBRC = 0.

Re: UPDATE statement not working , please help

vinod_vemuru2 — Tue, 11 May 2010 21:20:01 GMT

Hi,

If sy-subrc is zero and commit work is used, i can't see any possibility of failure. Check with your basis team if the update work processes are fine.

Thanks,

Vinod.

Re: UPDATE statement not working , please help

Former Member — Fri, 14 May 2010 18:40:46 GMT

Thank you all guys, there was some problem in code, now its fixed.

Good luck yuo all,

Angelo