TRUE - Has a border
FALSE - Does not have a border

Field names from result and field names in Datawindow must be the same

dw_1.bsl.get=WareHouseStock("BW")?$select=ItemCode,IVersionId,Batch,SysNumber,UoMCode,BinCode,RFID,OnHand,Details,Status

setvar=ls_columns=
for ll_loop=1 to <dw_1.columncount>
   addvar=ls_columns=<dw_1.columnname:[ll_loop]>,
next
messagebox=Columns: <ls_columns>

With CTRL+double-click you can modify column properties (default).

Disable this functionality by setting it to false.

Example

dw_2.crtldoubleclick=false

This is the file name of the datawindow formula (PSR-File name).

For set datawindow, use the init command dw_1.init=<psr-filename>

HTML/XLS

(only read)

Other form gets all object values from a datawindow object.

There is full access to all objects inside this datawindow object. For more information, see the PowerBuilder documentation.

messagebox=<dw_1.describe=itemcode.x>

dw_1.drag.auto=true  activates the auto-drag function

dw_1.drag.begin

dw_1.drag.end

dw_1.drag.cancel

See

setdynamicgridcols

setupcolumn

Default names for a dynamic columns are the data window name. This setting can change this default behavior.

See

setdynamicgridcols

setupcolumn

This is the ID and name from the window, which usually is the .psr file name of first datawindow dw_1 inside current window without folder name and postfix .psr.

messagebox=<dw_1.dwname>

Dynamic browse window (columns defined with Ctrl+NS)

With this variable you can define which fields should be invisible. In this case you can't see those fields or activate them in the window settings.

dw_1.unvisiblefields=field1;field2;field3...

see

dw_x.editablefields

Dynamic browse window (columns defined with Ctrl+NS)

With this setting you can define which fields are editable.

If you define this, it is not possible to edit any fields that were not defined.

In window settings it is only possible to edit fields that were defined in this setting or the setting is empty.

dw_x.editablefields=field1;field2;field3...

see

dw_x.unvisiblefields

true=allowed, false=not allowed. Default=true

Example: Structureview - set xls export to false because you cannot use this.

dw_4.setfilter=itemcode>'a'

dw_4.filter

messagebox=Current filtered: <filtercount>, current visible: <rowcount>

A right-click on a title presents a pop-up window with the definition of the the filter/sort of the list.

This command can deactivate this behavior.

dw_4.filtersort=false

If the value is not found, value=0. If the search syntax is not correct, the value is -1.

dw_2.find=itemcode='sofa' or itemcode='table'

setvar=ll_row=<value>

if <ll_row> n> 0 then

 messagebox=Description from <dw_2.itemcode:[ll_row].value>: &

            <dw_2.itemname:[ll_row].value>

end if

Example: Returns all columns from the stamm_stl_header window.

(only if the form is active)

setvar=ls_window=stamm_stlheader_edit

setvar=ls_dw=dw_1

setvar=ls_test=<system.window.[ls_window].form.[ls_dw].getcolumns>

messagebox=<ls_test>

Window. PSR-SQL

select OITM.ItemCode+'' || ItemCode FROM OITM inner join OITW where OITW.ItemCode = OITM.ItemCode

// you have one entry per Warehouse, 6 Entries for Item A if A is linked to 6 warehouses

dw_1=grouping=itemname

// now you have one line per Itemcode

dw_2.hscrollbar=true

dw_2.hsplitscroll=true

dw_2.horizontalscrollposition2=500

Example:

<dw_1.isselect> returns true/false for the current row

<dw_1.isselect:5> returns true/false for row 5

<dw_1.isselect:[ll_loop]> returns true/false for row from Variable ll_loop

Example:

dw_1.multiselect=true
dw_1.selectrow=5
messagebox=<dw_1.isselectonerow>   returns true

You can select multiple lines with the mouse, keyboard or with commands.

Activate or deactivate multiselect: select row with Shift/Control + rowfocuschange. See selectrow, deselectrow.

Example:

dw_1.multiselect=true

To check the selected rows:

<dw_1.isselect> return true/false for current row

<dw_1.isselect:x> return true/false for row x

<dw_1.isselectonerow> return true, if min one row is marked

<dw_1.getselectentrydata> return selected data from binary field

<dw_1.getselectentryssql> return first primary field from all selected rows, all Data in ", example "value1","value2", ...

<dw_1.getselectentryrow> return all selected rows

Examples:

dw_1.multiselect=true

messagebox=<dw_1.getselectentrydata>

tools=isql=select * from "OITM" where "ItemCode" in (<dw_1.getselectentrysql>)

Examples for Work order structures

1=landscape

2=portrait

dw_2.orientation=2

global function dw_1_rightclick

// function

end global

Parameters must be separated with "="

The DataWindow must only have string arguments.

Arguments are passed 1:1. Only 10 parameters max are allowed.

dw_1.retrieve=<str_parm.belnr_id>=<str_parm.belpos_id>

Retrieves only the maximum defined rows using the general setting or this can be overwritten with maxrow.

dw_1.maxrow=999999

Example:

dw_2.setdatefilter=fromdate

It is not required to set this in dw_1, but it is required in any further data window, dw_2...7.

See

dynamiccol

dynamiccolname

dw_2.setfilter=itemcode=[myitem]

dw_2.filter

Should the user define the filter, the parameter would be "user":

dw_2.setfilter=user

dw_2.filter

or you have 2 columns (example):

dw_2.setfilter=whscode="01" and color_id=1

dw_2.filter

dw_1.setposition=behind

dw_1.setposition=tobottom

dw_1.setposition=totop

Do not use this command. Beas has its own "redraw" mode with the following order:

dw_master - dw_1 - dw_2 ... dw_7 - rtf object - html object

Sorts the current data window.

Use the datawindow syntax for arguments. Placeholders are not allowed.

Only sort data that is loaded in the current datastore.

Information:

If you load the item list, Beas is loading the first 200 entries only.

If you define a setsort, Beas makes this setsort only for these 200 entries and not for the complete item list.

Use this function only if all data is loaded.

Example:

dw_2.setsort=u_matgrp,itemcode

dw_2.sort

// Should the user define the sorting, the parameter would be "user":

dw_2.setsort=user

dw_2.sort

This command is required, if you do not use a retrieve command and if work with dw_2...dw_7

dw_2.init=myfile.psr

dw_2.settransaction

Alternative:

dw_2.settrans

If connection to another database / table is required, use transaction method.

See

setdynamicgridcols

dynamiccolname

Creates a new DataWindow form:

sql2form=browse/edit=<sql command>

<dw_2.type> returns the type of window

The available return values are:

browse

edit

Grid windows and multiline edit windows are "browse" windows, all other windows are edit windows.

Set this with:

dw_x.design=..

dw_x.is_type

Define the link to udf name

Example for QC Sample:

dw_2.udf= qssudf

The system make the related udf1-4 fields visible and set all format properties automatically

Must be before form.opened event.

if name of target field is not "udf" then you must define this with udfcol

dw_2.udfcol=beas_qc_order_udf

True = 1/j/y/t ...

Example:

dw_2.visible=true

messagebox=<dw_2.visible>

Attention: Do not make dw_1 invisible.