topic Re: update syntax in Application Development and Automation Discussions

update syntax

Former Member — Mon, 26 Mar 2007 18:47:43 GMT

if flag is X i want to clear the flag and update the date and time. So far I have tried

if zcitorderout-flag = 'X'.
update zcitorderout set flag = space and erdat = wa_zcitorderout-erdat and erzet = wa_zcitorderout-erzet.

AND

if zcitorderout-flag = 'X'.
      zcitorderout-flag = space.
      zcitorderout-erdat = wa_zcitorderout-erdat.
      zcitorderout-erzet = wa_zcitorderout-erzet.
      modify zcitorderout.

Re: update syntax

former_member194669 — Mon, 26 Mar 2007 18:50:43 GMT

Please don't forget to give COMMIT WORK.

aRs

Re: update syntax

Former Member — Mon, 26 Mar 2007 18:51:30 GMT

neither of the above syntax work.. so i am looking for some syntax that will work

Re: update syntax

RaymondGiuseppi — Mon, 26 Mar 2007 18:52:31 GMT

Try theses syntax

if zcitorderout-flag = 'X'.
update zcitorderout 
  set flag = space 
       erdat = wa_zcitorderout-erdat 
       erzet = wa_zcitorderout-erze.
endif.

if zcitorderout-flag = 'X'.
      zcitorderout-flag = space.
      zcitorderout-erdat = wa_zcitorderout-erdat.
      zcitorderout-erzet = wa_zcitorderout-erzet.
      update  zcitorderout.
endif

Regards

Re: update syntax

Former Member — Mon, 26 Mar 2007 18:53:36 GMT

hi raymond do i need commit work after the update statement

Re: update syntax

ferry_lianto — Mon, 26 Mar 2007 18:58:29 GMT

Hi,

Please try this.


data: wa_zcitorderout like zcitorderout.

if zcitorderout-flag = 'X'.
  update zcitorderout 
  set flag = space 
       erdat = wa_zcitorderout-erdat 
       erzet = wa_zcitorderout-erze
  where <condition>.
endif.

AND 

if zcitorderout-flag = 'X'.
  wa_zcitorderout-flag = space.
  modify zcitorderout from wa_zcitorderout.
endif.

Regards,

Ferry Lianto