isql
Contents
This function allows you to simply create a report formula.
It is part of the object "tools"
tools=isql=<property>
Available properties
Property |
Description |
|
|---|---|---|
sql |
|
|
title |
the title of the window |
|
dwname |
the unique ID of the window. You must set this, otherwise some functions (example customization) will not work. |
Beas replaces the titles of field names with a 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 the following 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' |