On 3/15/10 6:46 PM, "Ronald Rudy" <ronchal...@gmail.com> wrote:
> I believe you want to look at this: > http://db.apache.org/derby/manuals/reference/sqlj32.html > > <http://db.apache.org/derby/manuals/reference/sqlj32.html> Specifically the > referential ON UPDATE in constraints. The only "ON UPDATE" actions that are > allowed are "NO ACTION" and "RESTRICT"; Derby does not appear to support > cascading updates. You can log a feature request, I believe there might > already be one for it based on this thread: > http://old.nabble.com/ON-UPDATE-CASCADE-in-derby-td1633870.html > > Incidentally I do believe that MySQL supports on update cascade with its > INNODB engine, and I do think MS SQL does as well > (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx) > Thank you for the pointer. I learn something new every day ;-). -- Rick Genter Principal Software Engineer Silverlink Communications rgen...@silverlink.com www.silverlink.com Office (781) 583-7145 Mobile (408) 398-7006 This e-mail, including attachments, may include confidential and/or proprietary information, and may only be used by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately