With the following commands you can define background colors for different statuses.

it's only working for columns, not other item types

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

Example:

dw_1.item.mycolumn.bold=true

if you set this outside the retrieve / load mode, you must set the command.
redrawallcolumns

to redraw all fields

Example: Red

dw_1.item.mycolumn.color=<rgb:255:0:0>

you can send a formula, 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

messagebox=<item.mycolumn.dbname>

messagebox=<item.mycolumn.dbtable>

Note: Not working in lists, only edit forms.

item.[itemname].detailbitmap=[command]

Example: open sales order from work order

item.mycolumn_pp.destroy

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

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

is displayed 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 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

with this command you can set the field as mandatory field.

if it's empty, you can't update the data

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

dw_1.item.mycolumn.setfocus

(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

Beas uses this to define click commands.

You can get the actual value

messagebox=<item.mycolumn.tag>

Text-object: set the Text to display
Column-object: set the Text of the object - title field (object name +"_t")

Note: Don't convert special character "~" which present a escape sign in datawindow syntax

Example ~t is tab, ~r~n is line feed and so on.

If ~ inside text, convert the string to DataWindow-Text syntax

dw_1.item.itemcode.title=The Item Code

return the type of column: column, text, bitmap, compute

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

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

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

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.

dw_1.item.mycolumn.x=200

setvar=ll_y=<dw_1.item.mycolumn.y>

replace follow ascii-entrys ~t = , < > ' " & ß with _ - : | | ' ' ss

warning-message, if space found

if more then 1 row, then check of unique

example in itemchanged-Event:

item.wkz_id.checkid

dw_1.item.mycolumn.value="hello world"

Get Value

messagebox=<dw_1.item.itemcode.value>

or values from all lines

setvar=ls_items=

for ll_loop=1 to <dw_1.rowcount>

  setvar=ls_items=<ls_items><dw_1.item.itemcode:[ll_loop].value>

next

messagebox=<ls_values>

if column type is text, Beas return the text of this object

Example:

messagebox=<item.menge_zeitje.values>

returns

displaynam[tab]value/displayname[tab]value...

In dropdown you can define 1=red,2=blue

in screen you see red, blue and so on

with this command it's possible to return the visible information

..value> = 2

..displayvalue> = blue

beas 9.3 PL 2 HF 2