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 InfoMaker expression function.
Using GetText ensures that the most recent data entered in the current column is evaluated.
InfoMaker does the conversion for you
If you have associated a validation rule for a column in the Database painter, InfoMaker automatically
converts the syntax to use GetText when you place
the column in a form.
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 Chapter 24, “DataWindow Expression and InfoMaker Functions.”
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.
