Try OpenEdge Now
skip to main content
Basic Database Tools
Table Tasks : Creating a table : Specifying validation criteria

Specifying validation criteria

You use validation criteria to control which records can be deleted from the table.
To specify table validation criteria:
1. Choose the Validation button. The Data Dictionary displays the Table Validation dialog box:
2. Specify the message you want the Data Dictionary to display when a user tries an invalid deletion. There is no limit to the number of characters you can enter. A message up to 63 characters long can fit onto the two message lines without scrolling.
3. Specify the criteria for valid deletions. For example, in the customer table, to restrict deleting customers to those customers who have no outstanding orders, enter the following criteria:
NOT (CAN-FIND(FIRST order OF customer))
4. Choose OK to return to the Add New Table window.