isql
Contents
This function allow you to create a report formular in very simple way
It's a part of object "tools"
tools=isql=<property>
follow properties are available
Property |
Description |
|
|---|---|---|
sql |
|
|
title |
the title of window |
|
dwname |
the unique id of the window. You must set this, otherwise some functions (example customizing) not working |
beas replace the titles of field names with standard description
Example:
tools=isql=title=My Item List<tab>dwname=mylist<tab>sql=select "ItemCode","ItemName" from "OITM"
In older functions you
tools=isql=<sql-statement or procedure>
This function generate a new window, result from sql-statement or procedure Example: item-Liste
tools=isql=select "ItemCode" from "OITM" order by "ItemCode"
You can set follow variables setvar=ititle=title from window Button1: x=1 Button2: x=2
Example Itemlist with Button setvar=ititle=my item list setvar=ibutton1=openitem=openwindow=artikel_edit.psr=s_parm1:<itemcode> setvar=ibutton1text=Open Item tools=isql=select "ItemCode","ItemName" from "OITM" order by "ItemCode"
Example Inventoryhistory tools=isql=execute beas_invhistory 'C11772' |