Update not working in NATIVE SQL

Former Member — Thu, 21 Jan 2010 10:45:42 GMT

Hi All,

I am using the following code to update two fields in isuser.table_ table. But it is not updating the same.

EXEC SQL.
    UPDATE misuser.table_4
    SET otype = :gc_otype1,
        objid = :gc_objid
    WHERE otype = :gc_otype
  ENDEXEC.
  IF sy-dbcnt = 0.
    WRITE: 'No rows updated'.
  ELSE.
    WRITE: sy-dbcnt, 'rows updated'.
  ENDIF.

When i use the same code to update only one field, its working. Can anybody help me on this?

Thanks

Nitesh

Re: Update not working in NATIVE SQL

former_member848108 — Thu, 21 Jan 2010 12:06:03 GMT

Hi Nitesh,

Try to run the update query using the query interface(e.g. T-Sql Query Analyzer, Oracle Developer, etc.), and check

if it's working as expected. This might help yo solving the issue.

Regards.

Ozcan.

topic Update not working in NATIVE SQL in Application Development and Automation Discussions

Update not working in NATIVE SQL

Re: Update not working in NATIVE SQL