ASSD - Ho(s)tel Management Software PMS 3

Menu item "Settings / Field Validation". Via the new validation rule "EX" you can now check any expression of programming language. In particular, dependencies of more fields can be checked: e.g. "Field 1" greater than "Field 2" or "Field 1" only needs to be filled if "Field 2" is filled. If the expression is wrong, an error message is displayed. Consequently, the expression defines the allowed values. In order to give the incorrect values, the expression can be put in brackets with NOT = !: "!(Expression)". The program expression is defined with an empty code in the control field (assignment "Settings / Field Validation, Detail2") in the ComboBox lists. If these 160 symbols are not enough, the field may be extended via codes "01" to "09". As a field name, any name can be used which is not already checked normally (e.g. user, cdate, wdate). Additionally, function "sqlx("SQLStatement")" returns the number of data records found. That is how the logic may be checked in any tables independent of current program fields, now. The command should be agreed with ASSD, should, if possible, use indices and has to select into an array. Alternatively command "execscript" may be used to run more commands. Even complete program runs may be mapped and avoid the constriction that SQL statements do not take data which is not stored yet, into consideration.