Property
|
read
|
write
|
Description
|
alignment=0...3
|
|
x
|
Alignment 0 - (Default) Left, 1 Right, 2 Center, 3 Justified
|
autohscroll=1/0
|
|
x
|
set horizontalscroll in column items
item.mycolumn.autohscroll=1
|
autovscroll=1/0
|
|
x
|
set verticalscroll in column items
item.mycolumn.autovscroll=1
|
background.<type>=<color>
|
|
x
|
with follow commands you can define background colors for different statis
it's only working for columns, not other item types
background.ok
|
Color if all ok
dw_1.item.mycolumn.background.ok=<color:backgroundcolor_ok>
dw_1.item.mycolumn.redraw
|
background.error
|
Color if error (field-Status=error)
dw_1.item.mycolumn.background.error=<color:backgroundcolor_error>
..
dw_1.item.mycolumn.status=error
redrawallcolumns
|
background.empty
|
color if field is empty of field-Status=empty
Example: OpenEvent. OK=green, Empty=read Background
dw_1.item.itemcode.background.ok=<color:backgroundcolor_ok>
|
with property status you can change the status of the field and related to this the background
dw_1.item.mycolumn.status=error
dw_1.item.mycolumn.redraw
or with setstatus you can change the status and can redraw the column automatically
dw_1.item.mycolumn.setstatus=error
if you change many properties outside load event, you can start the redraw for all columns with this command
redrawallcolumns
for redraw all fields
|
|
bitmapname=bmp\<bitmapname>
|
|
x
|
name from bitmapfile
(bmp, jpg, gif, png)
|
bold=true/false
|
|
x
|
Example:
dw_1.item.mycolumn.bold=true
if you set this outside the retrieve / load mode, you must set the command
redrawallcolumns
for redraw all fields
|
|
color
|
x
|
x
|
Example: Red
dw_1.item.mycolumn.color=<rgb:255:0:0>
you can send a formular too
dw_1.item.mycolumn.color='255~tif (left(ag_id,1)="A",255,0)'
or better with the modify command
dw_1.modify.mycolumn.color='255~tif (left(mysecondfield,1)="A",255,0)'
if you set this outside the retrieve / load mode, you must set the command
redrawallcolumns
for redraw all fields
|
|
coltype
|
x
|
|
|
dbcolumnname
|
x
|
|
return the column name
|
dbname
|
x
|
|
messagebox=<item.mycolumn.dbname>
|
|
dbtablename
|
x
|
|
messagebox=<item.mycolumn.dbtable>
|
|
destroy
|
|
x
|
|
displayonly=1/0
|
|
x
|
Only Column: set input-field to only view
|
dropdown
|
|
x
|
Create dropodwn window or open it
|
expression=<expressionvalue>
|
|
x
|
set expression (formel) (only computeobject)
|
escapement
|
|
x
|
Rotation on a field in 1/10° (0 - 3600)
Example: rotate the field "itemcode" 3 times
for ll_1=1 to 3
for ll_2=1 to 3650 step 100
dw_1.item.itemcode.escapement=<ll_2>
next
next
|
|
format=<format string>
|
|
x
|
Displayformat. Only Column and Compute Example: #,##0.00 = 3,000.34
|
formatstring
|
|
x
|
Properties:
background.ok (or bok)
background.error (or berr)
background.empty (or bemp)
status
bold
italic
color
text (Only Textfield or the Textfield "columnname+"_t" from column, replace comma to "&|")
Example
item.mycolumn=formatstring=bok=<rgb:100:255:100>,berr=<rgb:255:100:100>,bold=true,italic=true,text=My Field Description
If you set design-Properties as bold, italic e.c. and your Script is not in open- or itemchange-event, you must make a redraw
item.mycolumn.redraw
|
|
hscrollbar=1/0
|
|
x
|
displays in the control when all the data cannot be displayed at one time. Values are:
1 – Horizontal scroll bar is displayed.
0 – Horizontal scroll bar is not displayed.
|
|
italic=true=false
|
|
x
|
Italic on/off
dw_1.item.mycolumn.italic=true
if you set this outside the retrieve / load mode, you must set the command
redrawallcolumns
for redraw all fields
|
|
mandatory=true/false
|
|
x
|
with this command you can set the field as mandatory field.
if it's empty, you can't update the data
|
|
password=1/0
|
|
x
|
Only Column: set to password-field. You can see only "***"
|
protect=1/0
|
|
x
|
Activates and deactivates editing of a field
|
redraw
|
|
x
|
if you change design properties, example bold, italic, color, background color outside the load / retrieve events, you must redraw the properties
item.mycolumn.redraw
or for all commands
redrawallcolumns
|
|
rightclicktrigger
|
x
|
x
|
Define function of right click
|
setfocus=<column>
|
|
x
|
dw_1.item.mycolumn.setfocus
|
|
tabsequence=<x>
|
|
x
|
(only Columns): A number from 0 to 32000 specifying the position of the column in the tab order. A value of 0 takes the column out of the tab order and makes it read-only.
item.mycolumn.tabsequence=20
|
|
tag
|
|
x
|
beas use this, to define click commands.
You can get the actual value
messagebox=<item.mycolumn.tag>
|
|
text=<textvalue>
|
|
x
|
Only Text-Fields: set the Text to display
|
title=<textvalue>
|
|
x
|
dw_1.item.itemcode.title=The Item Code
|
|
type
|
x
|
|
return the type of column: column, text, bitmap, compute
|
|
simulatetype
|
|
x
|
define a "simulation" type for columns type char
use this example for udf or userfield
item.udf5.simulatetype=date
convert every manual entry to date format
item.udf5.simulatetype=#0.00
convert every manual entry to decimal format with 2 decimal places
String to Number is always working, if # is inside the format
beas 9.3 PL 2
|
|
visible=1/0
|
x
|
x
|
set visible true/false
|
status
|
|
x
|
change status between ok, error or empty
redraw background color, front color and some other properties, which you can define with formatstring
if you change it outside open/new event, you must send an redraw
dw_1.item.itemcode.status=error
dw_1.item.itemcode.redraw
|
|
setstatus
|
|
x
|
change status between ok, error or empty
redraw background color, front color and some other properties, which you can define with formatstring
Same as command "status", but it redraw the column automatically Beas 2020.02
dw_1.item.itemcode.setstatus=error
|
|
vsrollbar=1/0
|
|
x
|
displays in the control when not all the data can be displayed at one time. Values are:
1 – Vertical scroll bar is displayed.
0 – Vertical scroll bar is not displayed.
|
|
x,y,width,height
|
x
|
x
|
dw_1.item.mycolumn.x=200
setvar=ll_y=<dw_1.item.mycolumn.y>
|
|
