I noticed that in my Rainbow Portal (dB Version 1733) that I get 2 errors when I try to execute rb_DeletePortal.
The errors are due to the fact that the following 2 foreign keys aren't setup for cascading delete.
fk_rb_Tabs_rb_Portals
fk_rb_Modules_rb_Tabs1

I modified the foreign keys to include cascading delete and rb_DeletePortal seems to work like a charm.
Is there a reason that the following 2 fks aren't setup for cascading delete?

Thank you for your help in advance,
--Greg

hi glivengood, can you tell me in detail how to change or create the foreign keys in Ent Manager or what? thanks

G-

Sure thing. It sounds like you want to know how to add the deleting cascade to your setup
The way to do this is to
1. Bring up Enterprise Manager
2. Right Click on the rb_Tabs table in your rainbow dB
3. Chose Design View from the context menu
4. In the design view right click
5. select thh "Relationships..." Menu item from the context menu
6. Chose the Foreign Key in the Selected Relationship Combo Box (I don't remember the name, but it is in my previous post)
7. Click on the Delete on Cascade check box

Do the same bringing up the rb_Modules table for the other foreign key, which again I can't remember nor see as I am doing the post.

Let me know if this doesn't get you on your way,
--Greg