SQL compatibilty informations

Follow functions supported, but please don't use it:

 

you can set the select-command in placeholder. Use {} as sub-placeholder

setvar=ls_itemname=<select "ItemName" from "OITM" where "ItemCode"={itemcode,dbstring}>

 

Results additional available in value

wert1,wert2 ....

select "ItemCode","ItemName" from "OITM" where "ItemCode"='1111'
messagebox=ItemCode: <wert1>, ItemName: <wert2>

 

You can execute SQL commands with

sql.select=a,b
sql=select a,b
sqlca.select=a,b
sqlca.select a,b
select=a,b
select a,b