Since a user might have just entered a value in the column, validation rules refer to the current data value, which you can obtain through the GetText DataWindow expression function.
Using GetText ensures that the most recent data entered in the current column is evaluated.
PowerBuilder does the conversion for you
If you have associated a validation rule for a column in the Database painter, PowerBuilder automatically
converts the syntax to use GetText when you place the
column in a DataWindow object.
GetText returns a string. Be sure to use a data conversion function (such as Integer or Real) if you want to compare the entered value with a datatype other than string.
For more on the GetText function and text patterns, see the DataWindowReference.
You can refer to the values in other columns by specifying their names in the validation rule. You can paste the column names in the rule using the Columns box.
