UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

Former Member — Thu, 31 Aug 2006 11:07:32 GMT

Hi,

can any one tell me how to update database table with only those fields that have received a new value in the dialog screen(0100)

thanks

Re: UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

Former Member — Thu, 31 Aug 2006 11:10:32 GMT

Hi Bobby,

Once you identify the rows/data changed in your table.. you can use the below statement for updation in table

UPDATE dbtab FROM TABLE itab.

Effect

Mass update of several lines in a database table. Here, the primary key for identifying the lines to be updated and the values to be changed are taken from the lines of the internal table itab . The lines of the internal table must satisfy the same conditions as the work area wa in addition 1 to variant 2.

The system field SY-DBCNT contains the number of updated lines, i.e. the number of lines in the internal table itab which have key values corresponding to lines in the database table.

The return code value is set as follows:

SY-SUBRC = 0 All lines from itab could be used to update the database table.

SY_SUBRC = 4 At least one line of the internal table itab in the database table, had no line with the same primary key. The other lines of the database table were updated.

Regards,

Raj

Re: UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

Former Member — Thu, 31 Aug 2006 12:11:35 GMT

Hi,

By using UPDATE you an do this.

For updating particluar value use UPDATE <table> set (valus)

where <use key>. For more information use F1 Help.

Thnaks,

saleem.

topic UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG in Application Development and Automation Discussions

UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

Re: UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG

Re: UPDATING DATABASE TABLE USING THE CHANGED VALUES IN DIALOG