sqlca.update

Execute SQL update command

 

sqlca.update [table] set [field name]=[new value] where [where condition]

 

Note: don't use this command for changing SAP or Beas Standard fields.

if you work with place holders, you must convert this to correct format. See format place holders

 

Example:

setvar=ls_itemname="abc"
sqlca.update "U_MYTABLE" set "ItemName"=<ls_itemname,dbstring> where ...

 

 

see

format place holders

error handling