help with modify table.

[Former Member]

hi all,

i have a Table control (TC) and internal table (it) so when i modify the TC in a dynpro and i put save the code is:

loop at it_zhola.

move-corresponding it_zhola to zhola.

modify zhola.

endloop.

when this code is execute in the table are 3 fiels with 0 in the date field so insert 3 new rows. how can i insert this modification in the transparent table?

[Former Member]

Hi

You can use the

UPDATE <table>

SET <field> = <value

where <cond>

[jayanthi_jayaraman]

Hi,

Check this for sample code.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/abap/abap-co...

[Former Member]

Hi

loop at it_zhola.

update zhola set f1 = it_zhola-f1...

endloop.

commitwork.

please make the above mentioned changes.

Unless you commit work your data will not be updated in Database

BR,

Ravi

[Former Member]

Hi ,

you can use this update statement

<b>UPDATE <databasetable>

SET <field> = <value

where ><cond></b>

or

loop at it_zhola to wa_zhola.

<b>modify zhola(database table) from wa_zhola.</b>

endloop.

<b>

reward pts if helpful.</b>

Rgds,

Ajith