Re: Developer Tool for Building Triggers, Check Constraints

Adam,

Since you are already using ERwin, why not use it to create the check constraints and triggers? For check constraints, just define ERwin validation rules using the Validation Rule editor from ERwin's server menu. Once you define the validation rules you can attach them to columns using the Oracle column property editor. When the DDL is generated from ERwin, the check constraints will show up in the DDL.

For triggers, ERwin will create basic referential integrity triggers based on the relationships defined in ERwin. If you want to add more than referential integrity (or use DRI and before triggers), you can easily customize the way ERwin generates triggers.

-- 

Steve Liebler              [http://www.logicworks.com]
Senior Product Consultant  stevel_at_logicworks.com
Logic Works, Inc.          Phone: 609.514.2037

****************************************
*       Introducing ModelMart.         *
*   Now you can share ERwin models     *
*       without losing control         *
****************************************

Adam Warshaw <warsha-a_at_capital-re.com> wrote in article
<3240786F.686C_at_capital-re.com>...


> We are currently evaluating a copy of Vision Builder for our 


> developers and would like to know if anyone has other products 

> they could recommend.  We are looking for a tool that assists 

> the developers in creating database triggers/procedures/and 

> table check constraints.  Our platform is Oracle v7.2, the 

> developers are working on NT and are using PowerBuilder with 

> ER-Win.  Any suggestions would be appreciated.

> 

> warsha-a_at_capital-re.com

> Database Administrator

> Capital Reinsurance Company

>