Item

Item is an element on the datawindow

Item can be a text object, column or other visual elements

 

Examples:

 

let s=dw_1.items("itemcode"); // return the object itemcode
let s=dw_1.items.itemcode.value;  // return the object itemcode
let s=dw_1.items.itemcode[3].value // return value from field itemcode from row 3
let s=dw_1.items.itemcode.color=255; // change color to red
 
dw_1.items.itemcode.value="abc"; // change value from itemcode in current line to "abc"
dw_1.items.itemcode.x=100; // change position
 

Methods

Function

Description

isnull

check if value of item is null. return boolean

value

return value from an item, with NULL handling

 

 

Properties

Property

R

W

Type

Description

alignment

 

x

column

Define alignment (right/left)

autohscroll

 

x

column

activate automatic horizontal scroll

autovscroll

 

x

column

activate automatic vertical scroll

checkid

 

x

column

Check the column text field for mandatory field

color

x

x


Font Color of the item

coltype

x

 

column

return column type (string, number) of the item

create

 

x


create a new item

dbcolumnname

x

 

column

return the column name from datasource

dbname

x

 

column

return the datasource name

dbtablename

x

 

column

return the table name from datasource

displayonly

 

x

column

define, if field is editable nor not

dropdown

x

 

column

Return dropdown object

enabled

x

x

column

enable / disable an column item

format

 

x

column, computedfield

define the format of the view

height

x

x


Define the height of the item

hscrollbar

 

x

column

activate horizontal scrollbar

left

x

x


Define the left position of the item

original

x

 

column

return the original value

password

 

x

column

Define the column object as password field

protect

 

x

column

protect / unprotect an column item

rightclicktrigger

 

x

colum

define right click function in column field

setnull

 

x

column

set value from string to NULL

tabsequence

 

x

column

define order of fields, if you click TAB key

top

x

x


Define top position of the item

tooltip

 

x


Return the tooltip object

type

x

 


return type (column, text, line) of the item

value

x

x

column

return or set the value of object

visible

 

x


make field visible / unvisible

vscrollbar

 

x

column

activate vertical scrollbar

width

x

x


Define the width of the item