update (sql-command)

update (sql-command)

 

The syntax "update" has a double sense

Without a further command it is a window-update.

If it is a SQL-update it is the same as:

 

sql=update ...

 

Example

 

// updates a window

update

 

// Values are written back via SQL-command

setvar=ls_newmatch=...

sql=update "OITM" set "u_match"=<ls_newmatch,dbstring> where "OITM"."ItemCode"=<itemcode,dbstring>

 

 

Attention

 

hmtoggle_plus1use HANA-Syntax

select "OITM"."ItemCode" and not oitm.itemcode

use rpad() not space

use now() and not getdate()

more see select
hmtoggle_plus1use allways correct Format

dbstring = for Strings

num(x) for numbers

dbdate for Datetime

 

see select