ddbicon.pngDDBuilder: Selecting Tables Rules (Superseded)

DDBuilder has been superseded by the BASIS DBMS Data Dictionary module accessible from the BASIS IDE or the Enterprise Manager. Recommended for usage with ODBC/JDBC access to PRO/5, Visual PRO/5, BBj application data. DDBuilder is no longer included in the BBj download package as of version 12.0 but can be downloaded with Visual PRO/5.

Once data dictionary general rules have been defined, they can be selected for individual tables, as follows:

  1. In the tree view, select the desired table to display the General Table properties page.

  2. Click the Select Rules tab to display the Select Rules properties page.

  3. In the Rule type field, click one of the following rule types:

    • Update - Defines the criteria that must be met before existing records can be updated.

    • Insert - Defines the criteria that must be met before new records can be created.

    • Delete - Defines the criteria that must be met before existing records can be deleted.

    • Drop table - Defines the criteria that must be met before TAOS code can be used to delete the table from the data dictionary.

  4. The Current rules field displays all of the rules currently active for the table.( A table can use the same rule more than once.) Rules are executed according to the order specified in this field. To move a rule up or down the list, click the rule, then use the Move up and Move down buttons to move it to the desired location.

  5. To remove a rule from the Current rules field, either double-click the rule, or select it and then click the Remove button.

tablesel.png