Author Topic: Database cascade (Read 3828 times)

robertsong · « **on:** March 16, 2004, 03:27:09 pm »

Does anybody ever create deleting cascade relationship in EA(i am using EA3.51, the SQL Server7)? I guess the reason of can't setup cascade is the SQL Server7 doesn't yet have the property.

Have some suggestion?

Robert Song

robertsong · « **Reply #1 on:** March 17, 2004, 09:45:34 am »

Since no one reply my question, I guess what the reason. Didn't I post the question clearly or the Cascade is not commonly used in database design?

Thanks,

Robert Song

hd · « **Reply #2 on:** March 17, 2004, 01:28:15 pm »

For 3.51, highlight the table with the foreign key and press F10. highlight the foreign key in the lower list and select the Extended Properties button. You can set cascades here.

robertsong · « **Reply #3 on:** March 17, 2004, 03:47:23 pm »

Henk Dekker ,

Still can't find the cascade setup, My version of EA is 3.51.602.(Corporate Edition)

After follwing your suggest, click the Extended Properties, the contents of the dialog is: Index Properties: Unique,Clustered(check box) and Ascending, Decending(radio button).

Thanks,

Robert Song

hd · « **Reply #4 on:** March 17, 2004, 04:18:49 pm »

Cascade constraint settings were not avaliable until build 616. You will need to upgrade to make use of this facility. Version 4 build 720 is currently available.

Sparx Systems Forum

News: