Regards update

Former Member — Thu, 02 Jul 2009 16:15:30 GMT

im working to update table on the DB and for instance i check the value from <ls_obt>

when the specific DB records is exactly the same and after the update is done i get sy-subrc = 0 and sy-dbcnt = 1. but the records is the same way the update process is done?

this is the regular behavior ?

there is a way to do update just if the recodes is different?

UPDATE (lt_table) FROM <ls_obt> .

Nina

Re: Regards update

Former Member — Thu, 02 Jul 2009 16:21:00 GMT

HI,

UPDATE statment update's the database table from the work area if the record exists with the same Primary key as of in workarea.

Else if doesnot exist then inserts the record into the DB Table.

Check the F1 help for more info on UPDATE statement.

topic Regards update in Application Development and Automation Discussions

Regards update

Re: Regards update