update syntax

[Former Member]

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.

[Former Member]

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.

[former_member194669]

Please don't forget to give COMMIT WORK.

aRs

[Former Member]

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

[RaymondGiuseppi]

Try theses syntax

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

or

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

Regards

[Former Member]

hi raymond do i need commit work after the update statement

[Former Member]

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