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
select "OITM"."ItemCode" and not oitm.itemcode use rpad() not space use now() and not getdate() more see select |
dbstring = for Strings num(x) for numbers dbdate for Datetime |
see select