Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from andchi on Jan 24 at 3:31 AM Pierre and R. N. Wilhite thank you very much for your help. The solution was COMMIT WORK just you say.
Now it works.
| | | ---------------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. __.____._ |   _.____.__ |
