topic Re: ABAP DOUBT in Application Development and Automation Discussions

ABAP DOUBT

Former Member — Fri, 25 May 2007 08:14:39 GMT

Hi friends,

when i update a record in database table using update query all records are updated . what's the reason anyone can tell me.

Former Member — Fri, 25 May 2007 08:18:42 GMT

Hi,

I think u didn't used Where Condition.

Regards,

Padmam.

Former Member — Fri, 25 May 2007 08:22:35 GMT

In update statement specify the condition using WHERE.With out this condition the update statement will update all records in u r table.

Former Member — Fri, 25 May 2007 08:23:21 GMT

hi varadarajan ,

can u paste the update statement here

thanks,

ravinder

Former Member — Fri, 25 May 2007 08:24:40 GMT

hi,

i think u used in a loop. for updating a single record use index as

update table tablename index sy-index [ current record gets updated].

if helpful reward some points.

with regards,

suresh babu aluri.

Former Member — Fri, 25 May 2007 09:25:49 GMT

Hi,

If you are using a loop to update the table, use the work area from which you are

updating the values. The work are must have the primary keys of the table.

Thanks.

Abhijit