ERwin 2.5 Cascading Deletes/Updates with MS SQL 6.5 
Author Message
 ERwin 2.5 Cascading Deletes/Updates with MS SQL 6.5

Greetings All,

I using ERwin 2.5 to generate schema for my MS SQL 6.5 database.

My question is....Can I / how do I set up the Referential Integrity
values to allow Cascading Deletes/Updates throughout the dependent
tables in an MS SQL 6.x database?  

As it stands right now, my referential integrity is set at "Parent
Delete - - Cascade,"  "Parent Update - - Cascade"....

What am I doing wrong???  I've tried many different combinations, but
none give the desired results.

Regards,

David Templeman
**************************************************

*               www.SensorySIMS.com              *
*                                                *
*          Sensory Computer Systems              *
*  SIMS (Sensory Information Management System)  *
**************************************************



Tue, 02 Feb 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VB5: Updating recordset on MS SQL-Server 6.5

2. Delete a field in SQL Server 6.5

3. ADO 2.5 SQL Delete Problem

4. Delete a field in SQL Server 6.5

5. Send Update Statement to SQl 6.5

6. ERROR 40002 to MS SQL 6.5 VIA ODBC

7. Error doing update with VB 3.0 and SQL Server 6.5

8. Problems with VB4.0 and MS SQL Server 6.5

9. Cascade Deletes / Updates

10. Cascade Deletes and Updates

11. Record Locking in MS SQL Server 6.5

12. DAO Update Deadlocks SQL Server 6.5, but not 6.0

 

 
Powered by phpBB® Forum Software