Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from andchi on Jan 24 at 3:22 AM Hi Horacio,
Sorry for the delay but I was not in my work.
Finally the solution was to execute commit work....
EXEC SQL.
commit
ENDEXEC.
Thanks at all for your help.
I believe that we will need your help again because the native sl is something new for me.
| | | ---------------Original Message---------------
From: andchi
Sent: Wednesday, January 23, 2013 3:25 AM
Subject: How to Update a Database Table Field (Type Integer) Using NATIVE SQL
Hi. I am trying to update a database table field (type integer) using NATIVE SQL.
The code is
EXEC SQL .
UPDATE [KosmocarUsedNew].[dbo].[u_cars_sap]
SET: status = 0
WHERE plaisiono = :i_sernr
ENDEXEC.
It returns sy-subrc = 0 but the value does not update.
Is there anything else I need to do? or need more rights on the basis? |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
