ItemError Event

Return codes

Return Code	Action
0	Reject the data value and display an error message
1	Reject the data value and do not display a message
2	Accept the data value
3	Reject the data value but let the focus change

ItemChanged Event

Return codes

Return Code	Action
0	Accept the data value
1	Reject the data value
2	Reject the data value but let the focus change

RetrieveStart Event

How do I append data to a datawindow

In the RetrieveStart event the return code must be 2

Return 2

Return Codes

0 – (Default) Continue.

1 – Do not perform the retrieval.

2 – Do not reset the rows and buffers before retrieving the data from the database.

List of Functions Available in Datawindow Expressions

Expressions are most commonly used to create datawindow column property expressions. But the are also used to create filter and find strings.