Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from andchi on Jan 24 at 6:56 AM Yes you're right. I figured if running another exec sql statement after the update. Sorry but I have not never update again from SAP another DATABASE. Thanks for Your Help
| | | ---------------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. __.____._ | _.____.__ |