The dw_1 ( DataWindow ) or dw_2....dw_7 objects are visual components on each form.
This is a sub-object of the window object.
x = DataWindow 1 to 7. Usually, only DataWindow 1 is active (always).
In events you can define it with "this" (this = current datawindow).
Properties
Property |
R |
W |
Description |
|||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
accepttext |
|
x |
Accept text from the input field and store it in the data buffer. |
|||||||||||||||||
border=true/false |
|
x |
|
|||||||||||||||||
borderstyle=x |
|
x |
Specifies the style of the border of the control. Values are: box, lowered, raised, shadowbox. |
|||||||||||||||||
bsl.get |
|
x |
|
|||||||||||||||||
color |
|
x |
Set the color |
|||||||||||||||||
columncount |
x |
|
|
|||||||||||||||||
columnname=x |
x |
|
Return the name of the column with field number x. See example in columncount. |
|||||||||||||||||
create |
|
x |
Create a new item. See create. dw_2.create=column=id=userfield1,name=myfield |
|||||||||||||||||
createdataobject
|
|
x |
createdataobject=style=sqlsyntax Example dw_2=createdataobject=grid=select "ItemCode" from "OITM" |
|||||||||||||||||
crtldoubleclick=true/false |
|
x |
|
|||||||||||||||||
dataobject |
x |
x |
|
|||||||||||||||||
dataxxxx (XML/XLS,LFO) |
x |
|
|
|||||||||||||||||
deleterow=<row> |
|
x |
Delete row <row> |
|||||||||||||||||
describe=x |
x |
|
|
|||||||||||||||||
deselectrow=x |
|
x |
Deselect a row (see multiselect) |
|||||||||||||||||
design=<designtype> |
|
x |
||||||||||||||||||
drag=<propertie> |
|
x |
|
|||||||||||||||||
dynamiccol=true/false |
|
x |
|
|||||||||||||||||
dynamiccolname |
|
x |
|
|||||||||||||||||
dwname |
x |
|
|
|||||||||||||||||
unvisiblefields |
x |
x |
|
|||||||||||||||||
editablefields |
x |
x |
|
|||||||||||||||||
enabled=true/false |
|
x |
Enabled datawindow true/false |
|||||||||||||||||
excelexport=true/false |
|
x |
|
|||||||||||||||||
filter |
x |
x |
Take over the filter |
|||||||||||||||||
filtercount |
x |
|
|
|||||||||||||||||
filtersort |
|
x |
|
|||||||||||||||||
find
|
|
x |
|
|||||||||||||||||
find=<propertie> |
|
x |
Find the row which agrees with the property. Return value is stored inside "value". Example: dw_1.find=itemcode="b005" |
|||||||||||||||||
getcolumns |
x |
|
|
|||||||||||||||||
getrow |
x |
|
Gets the current row. |
|||||||||||||||||
getselectenrtyrow |
x |
|
Returns the selected rows. For example: 5,10,11,12 |
|||||||||||||||||
getselectentrydata |
x |
|
Returns the values of the primary-key from the select rows and current row, Example: value1,value2,... |
|||||||||||||||||
getselectentrysql |
x |
|
Returns the values in SQL-style of the primary-key from select rows and current rows example: 'value1','value2',... |
|||||||||||||||||
grouping=field |
|
x |
|
|||||||||||||||||
horizontalscrollposition |
x |
|
Returns the horizontal scroll position. |
|||||||||||||||||
horizontalscrollposition=x |
|
|
Sets the horizontal position. |
|||||||||||||||||
horizontalscrollposition2=x |
|
x |
|
|||||||||||||||||
horizontalscrollsplit=x |
|
x |
Defines position of the split bar. |
|||||||||||||||||
hscrollbar=true/false |
|
x |
Horizontal scroll bar |
|||||||||||||||||
horizontalscroll=true/false |
|
x |
Disable or enable horizontal scroll function. Standard = true If you insert a ue_tab or ue_code_editor, the horizontal scroll is automatically disabled. |
|||||||||||||||||
hsplitscroll=true/false |
|
x |
Enables/disables the horizontal split function. |
|||||||||||||||||
importxxxxx |
|
x |
Import from other source into the Datawindow. See export/import |
|||||||||||||||||
init=<datawindowfile.psr> |
|
x |
||||||||||||||||||
initcols
|
|
x |
Columns are initialized and formatted.
dw_1.initcols |
|||||||||||||||||
insertow=<row> |
x |
x |
Insert row after "row". If row = 0 then insert row at the end. |
|||||||||||||||||
isselect |
x |
|
|
|||||||||||||||||
isselectonerow |
x |
|
|
|||||||||||||||||
item.x=y |
|
x |
Accesses the item object of the DataWindow. See item. |
|||||||||||||||||
lastobject |
x |
|
Returns the last changed item. |
|||||||||||||||||
lastrow |
x |
|
Returns the row, in which the last item was changed |
|||||||||||||||||
loadpsr=file |
|
x |
load this psr file with data inside the file |
|||||||||||||||||
maxrow |
x |
x |
define max. rows, which the retrieve command can loading |
|||||||||||||||||
markierung=j
|
|
x |
Is the marking activated, the current line is always be marked in the marking color. |
|||||||||||||||||
modify |
|
x |
||||||||||||||||||
move=x,y,width,height |
|
x |
With this function we can set the x,y,wifdth and height values in one single row. |
|||||||||||||||||
multiselect=true/false |
|
x |
|
|||||||||||||||||
order1, order2 |
x |
|
Returns the current SQL order. |
|||||||||||||||||
orientation |
|
x |
|
|||||||||||||||||
|
x |
Print DataWindow dw_2.print |
||||||||||||||||||
printwithdialog |
|
x |
Print DataWindow with print dialog dw_2.printwidhtdialog |
|||||||||||||||||
redraw / setredraw / freeze |
|
x |
Redraw / activate redraw / deactivate redraw |
|||||||||||||||||
rightclick |
|
|
|
|||||||||||||||||
reset |
|
x |
Resets the DataWindow |
|||||||||||||||||
retrieve=[parameter] |
|
x |
|
|||||||||||||||||
rowcount |
x |
|
Returns the count of rows. |
|||||||||||||||||
rowmove=fromrow=torow |
|
x |
Moves a row from the source to the target row. dw_2.rowmove=3=5 |
|||||||||||||||||
saveasxxxxx |
|
x |
Export, save datawindow. See export/import. |
|||||||||||||||||
scrolltorow=<row> |
|
x |
Scroll to row. |
|||||||||||||||||
selectedtext |
x |
|
Returns the marked text from a text field item. |
|||||||||||||||||
selectrow=x |
|
x |
Selects a row (see multiselect). |
|||||||||||||||||
setdatefilter=<fieldname> |
|
x |
|
|||||||||||||||||
setdetailheight=v1=v2=v3
|
|
x |
setdetailheight from row v1 to row v2 with height v3 |
|||||||||||||||||
setdynamicgridcols |
|
x |
|
|||||||||||||||||
setfilter
|
x |
x |
|
|||||||||||||||||
setposition=[position] |
|
|
|
|||||||||||||||||
setrow=<row> |
|
|
Set currentrow to row |
|||||||||||||||||
setsort
|
x |
x |
|
|||||||||||||||||
settransaction |
|
x |
|
|||||||||||||||||
setupcolumn |
|
x |
|
|||||||||||||||||
sort |
x |
x |
Take over the setting. See setsort. |
|||||||||||||||||
sql2datawindow |
|
x |
|
|||||||||||||||||
sum=<columnname> |
x |
|
Returns the sum of a columns from all rows, for example: messagebox=<dw_1.sum=onhand> |
|||||||||||||||||
tableselect=x |
x |
x |
Get / Set the SQL Statement of the DataWindow. setvar=mysql=<dw_2.tableselect> tools=globalreplace=mysql=[c_parm1]=<str_parm.c_parm1,#0> dw_2.tableselect=<mysql> Important: Do not use this with dw_1, but only in sql event. |
|||||||||||||||||
template |
|
x |
||||||||||||||||||
transaction |
|
x |
||||||||||||||||||
type |
x |
|
|
|||||||||||||||||
update |
|
x |
Updates changes from DataWindow to current Database or Source, which is connected to the Datawindow (see the dw_x.transaction property). |
|||||||||||||||||
udf |
|
|
|
|||||||||||||||||
udfcol |
|
|
Define target UDF Fields, if not same as udf name |
|||||||||||||||||
verticalscrollposition |
x |
|
Returns the vertical scroll position. |
|||||||||||||||||
verticalscrollposition=y |
|
x |
Sets the vertical scroll position. In the (function) verticalscrollposition event the position can be set to 0 to disable the scroll functionality for this window (only dw_1). global function verticalscroll dw_1.verticalscrollposition=0 end global |
|||||||||||||||||
visible=true/false |
x |
x |
|
|||||||||||||||||
vscrollbar=true/false |
|
|
Vertical scrollbar |
|||||||||||||||||
verticalscroll=tru/false |
|
x |
Enables/disables the vertical scroll. If you insert a ue_tab or ue_code_editor, the vertical scroll is automatically disabled. |
|||||||||||||||||
where1, where2, where3 |
x |
|
The current SQL filter, which is active in the dw_1 formula. |
|||||||||||||||||
x,y,width,height |
x |
x |
|
Events
Event Name |
Description |
delete |
Before line deleted |
deleted |
after line deleted |
doubleclick |
mouse left double click |
inserted |
after inserted new line |
itemchanged |
after changed an item |
load |
after loading / retrieve the datawindow |
rightclick |
mouse right lick |
rowfocuschange |
before row change |
rowfocuschanged |
after row change |
update |
while update datawindow (direct sql update) |
updated |
after update datawindow (direct sql update) |