Update Ztable in database

[Former Member]

hai,

i want to update the database of a ztable with one condition.wht i need to do now.

regards,

Max

[Former Member]

Use

IF <DATA> EQ <CONDITION>.

UPDATE <TABLE> FROM <WAREA>.

ENDIF.

or UPDATE proj SET txtsp = sy-langu WHERE pspid = wa_project-pspid.

Please post your code for better response.

Regards

Kathirvel

[Former Member]

just write a program ,demo is -

update ztable set field1 = '123' where field2 = '2' and

field3 = '3' .

[Former Member]

loop at itab.
update ztable set field1 = value1
where field2 = itab-value2 .
endloop.

[Former Member]

Hi,

Write a program and using UPDATE the field with the condition.

UPDATE <filed> where <condition>

regards

Sabu

[former_member508729]

Hi,

you can update ur z table like

update ztable

set fields to be updated

where ur condition

Regards

Ashutosh

Reward points if helpful

Message was edited by:

ashutosh ambekar

[Former Member]

UPDATE sflight SET   seatsocc = seatsocc + 3 
               WHERE carrid   = 'LH'   AND 
                     connid   = '0400' AND 
                     fldate   = '20010228'.

[Former Member]

HI Raju,

welcome to SDN.

just have a button ,so when u press the button ,hav the screen fields like ur screen and statement like

_______________________

tables Ztable.

case sy-ucomm.

when 'button1'.

INSERT ZTABLE .

endcase.

_______________________

regards,

siva

[alex_m]

write a code for that condition, if success update the table.

Alex