ISVALID( field )

fieldThe name of a DECIMAL, REAL, or alien data TYPE field.
Return:ISVALID returns a single Boolean value.

The ISVALID function validates that the field contains a legal value. If the contents are not valid for the declared value type of the field (such as hexadecimal values greater than 9 in a DECIMAL), ISVALID returns FALSE, otherwise it returns TRUE.


MyVal := IF(ISVALID(Infile.DecimalField),Infile.DecimalField,0);
//ISVALID returns TRUE if the value is legal

See Also: TYPE Structure, DECIMAL, REAL