Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from andchi on Jan 23 at 11:01 AM Hi Horacio Thanks for the reply. All the cases mentioned are okay . 1. the database server is Microsoft sql server. 2. I am connecting to the database via excec sql 3. yes,the user i use has the rights to update 4. yes the database table has update right granted for the user 5. the value i want exists . 6. There is no other exec sql statement after this update So,i still have problem.
| | | ---------------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. __.____._ | _.____.__ |