isql

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

 

select ...

execute ...

 

Example:

select "ItemCode","ItemName" from "OITM"

execute beas_invhistory 'C11772'

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"

 

hmtoggle_plus1Syntax for beas 9.2 PL 5 or older

 

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

setvar=ibutton[x]=objectname=functions

setvar=ibutton[x]text=Buttonname

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'