RE: NeededByEOF0

Hi Giulio,

Thanks for the reply - however no, I'm using Oracle, 8.1.7.4.0 with JDBC
driver from classes12.zip

Cheers
Igor

-----Original Message-----
From: Giulio Cesare Solaroli [mailto:[email protected]]
Sent: 21 July 2004 19:01
To: Clark, Igor
Cc: '[email protected]'
Subject: Re: NeededByEOF0


Igor,

are you using a FrontBase adaptor?

It was a long time ago, so I can be completely wrong, but I remember a 
similar message coming out from the FrontBase adaptor.

If this is your case, try to contact the FrontBase support; they will 
definitely help your.

Regards,

Giulio Cesare Solaroli

On 21 Jul 2004, at 17:50, Clark, Igor wrote:

> 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.
> _______________________________________________
> EOF mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/eof