NeededByEOF0
"Clark, Igor" <[email protected]> Wed, 21 Jul 2004 16:50:06 +0100
| Newsgroups | gmane.comp.web.webobjects.eof |
|---|---|
| Message-ID | <D808EA148335074698927652E8E5182F056ECC2E@ukapphdevmsx01.ukapd.astrazeneca.net> |
Hi folks, getting a strange problem. I have a Study <<--> Site. I have a form in which I edit an individual Study. This form has a selection box which contains all available sites, with study.site bound to the selection binding on the WOPopUpButton. Simple stuff. When I edit an existing study, change the Site, and try to save, for some reason EOF tries to update the Site table as well, and causes a primary key integrity constraint on the Site table to be triggered. Not only this, but it generates SQL for which I have no explanation (names changed to protect the guilty): "UPDATE SITE SET ID_SITE = ? WHERE ID_SITE = ?" withBindings: 1:<blah>(NeededByEOF0), 2:<blah>(NeededByEOF0)> What's NeededByEOF0? A search of the archives for NeededByEOF0 yields problems with flattened relationships and propagates primary key, but there are no flattened relationships between Study and Site, or any use of propagates primary key anywhere. Does anybody have any ideas or clues as to where to start looking to fix this? Makes not a jot of sense to me. Thanks Igor.