How to write native SQL for UPDATE

Former Member — Tue, 10 Feb 2009 10:13:04 GMT

Hi All,,

Now I need to write a native sql for updating fields in the database table.

when i write like this


 exec sql.
    UPDATE ZTAB_GLTR_DATA
       SET DOCUMENT_ID  = :w_id
     WHERE COMPANY_CODE = :fs_gltr_data-company_code and
               GLTRANID = :fs_gltr_data-gltranid and
                GLROWID = :fs_gltr_data-glrowid
  endexec.

it is working fine

now i need to update two fields for that i wrote like this


 exec sql.
    UPDATE ZTAB_GLTR_DATA
       SET DOCUMENT_ID  = :w_id, POST_DATE  = :w_date
     WHERE COMPANY_CODE = :fs_gltr_data-company_code and
               GLTRANID = :fs_gltr_data-gltranid and
                GLROWID = :fs_gltr_data-glrowid
  endexec.

which is leading to dump.

can any ony tell me how to write the code for updating two fields......

Re: How to write native SQL for UPDATE

Former Member — Tue, 10 Feb 2009 11:17:59 GMT

Hi,

You check wheater :w_date field is having value while debugging.

Regards,

Joan

Re: How to write native SQL for UPDATE

Former Member — Tue, 10 Feb 2009 11:20:02 GMT

Yes w_date has value

topic Re: How to write native SQL for UPDATE in Application Development and Automation Discussions

How to write native SQL for UPDATE

Re: How to write native SQL for UPDATE

Re: How to write native SQL for UPDATE