RE: [Rainbowportal-devel] error when removing custom module from tab (RC3 )

[Plowman, M. <MPl...@bc...>]

As usual, I found the problem right after emailing the question.
 
I had forgotten to tick the "Cascade Delete Related Records" box in the
relationship definition, although to be fair, I can't find this requirement
documented anywhere...
 
Cheers,
Mark

-----Original Message-----
From: Plowman, Mark [mailto:MPl...@bc...]
Sent: 02 August 2004 15:25
To: rai...@li...
Subject: [Rainbowportal-devel] error when removing custom module from tab
(RC3 )



Hi, 

I have some custom modules which each their own table. 
Each module is set up as a private assembly and the tables have a
relationship with rb_Modules as outlined in the documentation "Whitepapers -
Rainbow Portal March 2003"

i.e. rb_Modules.ModuleID -> rb_imagealbum.ModuleID (for the error below) 

If I try to remove a module from a tab whilst the module has data associated
with it in the module's table (eg rb_imagealbum) then I get the following
error:


DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_rb_imagealbum_rb_Modules'. The conflict occurred in database 'Rainbow',
table 'rb_imagealbum', column 'ModuleId'

I can remove the module if there is no data. 

This happens on all my custom modules that have their own databases, but not
on any of the core modules (that I have noticed anyway) so obvciously I'm
missing something in my code somewhere.

Does anyone have any idea what I'm missing? 

Cheers, 
Mark 


  _____  

This message is intended only for the addressee(s) and may be confidential.
Access to this email by anyone else is unauthorised. Any opinions expressed
in this email do not necessarily reflect the opinions of BCA. Any
unauthorised disclosure, use or dissemination, either in whole or in part is
prohibited. If you are not the intended recipient of this message please
notify the sender immediately. BCA, Greater London House, Hampstead Road,
London. NW1 7TZ. Tel: 020 7760 6500. This message has been checked for all
known viruses by the MessageLabs Virus Scanning Service.

  _____  



***************************************************************************
This message is intended only for the addressee(s) and may be confidential.
Access to this email by anyone else is unauthorised.  Any opinions
expressed in this email do not necessarily reflect the opinions of BCA.
Any unauthorised disclosure, use or dissemination, either in whole or in
part is prohibited. If you are not the intended recipient of this message
please notify the sender immediately.  BCA, Greater London House,
Hampstead Road, London. NW1 7TZ. Tel: 020 7760 6500. This message has been
checked for all known viruses by the MessageLabs Virus Scanning Service.
***************************************************************************