Progress
Basic Database
Tools


Specifying Validation Criteria

Follow these steps to specify table validation criteria:

  1. Choose the Validation button. Progress displays the Table Validation dialog box:
  2. Specify the message you want Progress 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:
  4. NOT (CAN-FIND(FIRST order OF customer)) 
    

  5. Choose OK to return to the Add New Table window.

See the "Creating a Trigger" section in "Trigger Tasks," for more information on creating triggers.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095