form events

The SQL statement is saved in variable sys_sql

You've the possibility to change this

NOTE: High risc. After Beas Update you must check, if your customizing is running.

global function form_readsql

tools=globalreplace=sys_sql=<old part>=<new part>

end global

Example:

Operation catalog. We want to replace the description. We want to insert this in brackets

from "Drilling" to "(Drilling)" - MSSQL Solution (in HANA all is upper case)

Proplem: Field names start " and end with "

If we want to define a variable, we must use alternative signs

 
global function form_readsql

// char 34 = "

// char 39 = '

setvar=boy_old= <char 34>beas_ag<char 34>.<char 34>bez<char 34>

setvar=boy_new=<char 39>(<char 39>+"beas_ag"."bez" +<char 39>)<char 39>

tools=globalreplace=sys_sql=<boy_old>=<boy_new>

end global

Here you can define the new positions of all elements related to new size of current form

global function form_resize

...

end global