topic Re: Update Statement in Application Development and Automation Discussions

Update Statement

Former Member — Fri, 24 Aug 2007 05:47:23 GMT

Which of these statements is correct. caz the ABAP editor gives no syntax error on any of these.

UPDATE PA0003 SET AEDTM = SY-DATUM UNAME = SY-UNAME BDERR =

VALID_DATE WHERE PERNR = INNNN-PERNR.

UPDATE PA0003 SET: AEDTM = SY-DATUM , UNAME = SY-UNAME , BDERR = VALID_DATE WHERE PERNR = INNNN-PERNR.

Re: Update Statement

Former Member — Fri, 24 Aug 2007 05:48:48 GMT

Both are correct

Re: Update Statement

Former Member — Fri, 24 Aug 2007 05:49:27 GMT

If both statement is true.

Then plz debugg your program and see the above mentioned syantax effec. As data is coming properly or not.

regards,

rewards point.

Re: Update Statement

Former Member — Fri, 24 Aug 2007 05:50:53 GMT

Hi,

Try this one always put try code when use update.

TRY.

UPDATE (table)

SET (set_expr)

WHERE (condition).

CATCH cx_sy_dynamic_osql_error.

MESSAGE `Error in update!` TYPE 'I'.

ENDTRY.

Rewards points if it is useful.

Re: Update Statement

seshatalpasai_madala — Fri, 24 Aug 2007 05:52:07 GMT

Hi,

Both are correct <b>as you might be knowing ':' is the operator used to list objects seperated by commas the second syntax is also fine.</b>

Regards,

Sesh

Re: Update Statement

Former Member — Fri, 24 Aug 2007 05:58:19 GMT

<b>both do the same</b>.

In 1st stament u r updating AEDTM , UNAME , BDERR fields of DB table hitting it only once.

In 2nd stament u r updating AEDTM , UNAME , BDERR fields of DB table one by one hitting the table thrice.

So 2nd is prefferable.

reward if helpful

Re: Update Statement

Former Member — Fri, 24 Aug 2007 06:15:32 GMT

For the 1st statement i got the three fields updated for the given PERNR

But the second statement changes BEDRR field of the given PERNR and AEDTM and UNAME for each and every entry in the table. damn it changes the whole table.

Message was edited by:

bilal sohaib