topic Re: modify syntax in Application Development and Automation Discussions

modify syntax

Former Member — Tue, 27 Mar 2007 15:37:04 GMT

modify wa_ztable set flag = 'X'.

what is wrong with the above code

i merely want to update flag to X for all records

Re: modify syntax

RichHeilman — Tue, 27 Mar 2007 15:39:21 GMT

I think it is something like this.......

modify wa_ztable transporting flag = 'X'.

Regard,

RIch Heilman

Re: modify syntax

former_member194669 — Tue, 27 Mar 2007 15:40:31 GMT

change it as

loop at wa_ztable.

wa_ztable-flag = 'X'.

modify wa_ztable .

endloop.

aRs

Re: modify syntax

Former Member — Tue, 27 Mar 2007 15:40:43 GMT

wa_ztable-flag = 'X'

modify wa_ztable where flag = space transporting flag.

Max

Re: modify syntax

RichHeilman — Tue, 27 Mar 2007 15:40:48 GMT

Nop, I don't think you can do that.

Regards,

RIch HEilman

Re: modify syntax

Former Member — Tue, 27 Mar 2007 15:40:55 GMT

Hi,

<b>If WA_ZTABLE is a DDIC table then..</b>

UPDATE WA_ZTABLE SET FLAG = 'X'

WHERE FLAG = ' '.

<b>If WA_ZTABLE is a internal table.</b>

WA_ZTABLE-FLAG = 'X'.

MODIFY WA_ZTABLE TRANSPORTING FLAG WHERE FLAG IS INITIAL.

Thanks,

Naren

Re: modify syntax

suresh_datti — Tue, 27 Mar 2007 15:41:22 GMT

Use the following.

wa_ztable-flag = 'X'.

modify wa_ztable transporting flag.

~Suresh

Re: modify syntax

Former Member — Tue, 27 Mar 2007 15:42:47 GMT

Hi,

Please try this.


modify ztable from wa_ztable transporting flag = 'X'.


or 


update ztable 
set flag = 'X' 
where field1 = <condition>
  and field2 = <condition>.

Regards,

Ferry Lianto