Re: Delete cascade?
Re: Delete cascade?
- Subject: Re: Delete cascade?
- From: Peter Vandoros <email@hidden>
- Date: Mon, 19 Mar 2007 14:08:15 +1100
Hi Ian,
WebObjects does this because it needs to bring all the EO's into memory
to process the delete rules specified in your EOModel.
Regards
Peter
Ian Joyner wrote:
I just noticed in my system that if I have the cascade delete rule set
on a to-many relationship in EOModeler that the deletes happen one by
one.
That is if I have a master record with three detail records, WO issues
three SQL DELETEs.
The setup is, each record has a primary key PRIMARY_KEY, which relates
to the owned records which have OWNER_KEY. To do the delete cascade, I
would think that DELETE FROM <owned table> WHERE OWNER_KEY =
<PRIMARY_KEY of owner> would suffice.
Have I got something set up wrong here, or am I missing something?
Thanks
Ian Joyner
Sportstec
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
Peter Vandoros
Software Engineer
Etech Group Pty Ltd
Level 3/21 Victoria St
Melbourne VIC 3000
Australia
Ph: +61 3 9639 9677
Fax: +61 3 9639 9577
----------------------------------
IMPORTANT: This e-mail message and any attachments are confidential and
may be privileged. If received in error, please reply to this message
and destroy all copies and any attachments. You should check this
message and any attachments for viruses or defects. Our liability is
limited to resupplying any affected message or attachments. For more
information about Etech Group, please visit us at
http://www.etechgroup.com.au.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden