We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-dev] How to Update a Database Table Field (Type Integer) Using NATIVE SQL

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Question from andchi on Jan 23 at 3:24 AM
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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
andchi  
 
View this online
Ask a new question
 
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language