Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Andchi on Mar 26 at 9:39 AM Thanks Horacio...
I found the solution from another posting you was answered...
I replaced the command SET taxpower = taxpower with SET taxpower = :taxpower and the value was stored.
| | | ---------------Original Message---------------
From: Andchi
Sent: Tuesday, March 26, 2013 6:31 AM
Subject: Native SQL in Updating Numeric Field to an External MS SQL Database
Dear all,
i've got a problem in updating numeric fields to an external MS SQL
Server database.
The code is:
data: taxpower type i.
try.
EXEC SQL .
UPDATE [KosmocarUsedNew].[dbo].[u_cars]
SET taxpower = taxpower
WHERE ID = :i_site
ENDEXEC.
EXEC SQL.
commit
ENDEXEC.
catch cx_sy_native_sql_error into lo_exc_ref.
lv_error_text = lo_exc_ref->get_text( ).
lv_len = strlen( lv_error_text ).
lv_len = lv_len - 50.
lv_error_text1 = lv_error_text(50).
lv_error_text2 = lv_error_text+50(lv_len).
lv_error = 'X'.
message i398(00) with lv_error_text1 lv_error_text2.
endtry.
The database field "TAXPOWER" is also type I.
The return code of the procedure is "0" but sql databse field is unchanged.
When i pass the value in this way : SET taxpower = '20000' ,then the update is succesful.
Thanks and regards,
Andromachi. |
| Reply to this email to post your response. __.____._ |   _.____.__ |
