topic Re: update database table in Application Development and Automation Discussions

update database table

Former Member — Wed, 07 Mar 2007 13:26:35 GMT

Hello All,

I have a reqmnt. I am having a table created by user and I need to update few values in it. The scenario is there is table ZTAB and there is field F1 , i need to insert values of F1 in field F2, where FI is not initial. Please check out my logic.

itab like table of ZTab,

wa like line of itab,

Select * from ZTAB into itab.

loop at itab into wa where F1 IS NOT INITIAL.

wa-f2 = WA-f1.

**Here is doubt, shud i use modify or append***

append WA or modify wa to itab.???

endloop.

Modify ZTAB from itab.

thanks and regards,

Gaurav

Re: update database table

Former Member — Wed, 07 Mar 2007 13:28:31 GMT

can someone suggest me something better?

Re: update database table

Former Member — Wed, 07 Mar 2007 13:28:44 GMT

Hello Gavrav,

DO like this:


itab like table of ZTab,
wa like line of itab,
Select * from ZTAB into itab.
loop at itab into wa where not F1 IS INITIAL. " Check here
wa-f2 = WA-f1.
***Here is doubt, shud i use modify or append****
modify itab from wa.    " Check here
endloop.
Modify ZTAB from itab.

If useful reward.

Vasanth

Message was edited by:

Vasanth M

Re: update database table

Former Member — Wed, 07 Mar 2007 13:30:37 GMT

Hi,

Please try this.


...

 modify itab from wa.
endloop.

modify ztab from table itab.

Regards,

Ferry Lianto

Re: update database table

Former Member — Wed, 07 Mar 2007 13:31:01 GMT

as you want just to modify the existing record with value F , just use modify

modify itab from wa.

Re: update database table

Former Member — Wed, 07 Mar 2007 13:31:39 GMT

one more thing

, do i need to use

append wa . after wa-f2 = WA-f1.

thanks,

Gaurav

Re: update database table

Former Member — Wed, 07 Mar 2007 13:32:09 GMT

Hi ,

You need to use only modify, no need to append wa.

inside the loop use

modify itab from wa.

itab like table of ZTab,

wa like line of itab,

Select * from ZTAB into itab.

loop at itab into wa where F1 IS NOT INITIAL.

wa-f2 = WA-f1.

modify itab from wa.

endloop.

Modify ZTAB from itab.

Hope it helps

regards,

saumya

Re: update database table

Former Member — Wed, 07 Mar 2007 13:32:59 GMT

No need of Append WA

Re: update database table

Former Member — Wed, 07 Mar 2007 13:57:50 GMT

Thanks All for you replies,

i have given points to ALL of you guys, but please if you have not received points do let me know, sometimes its an error in point allocation system