Here is what I did,
From "Deal" I have two relations like this,
(Name,target)
(Quotes,Quote) using deal_id. And reverse is (Deal,Deal)
(AcceptedQuote,Quote) using quote_id.And reverse is (DealForAcceptedQuote,Deal)
But then when I try to set particular Quote as "AcceptedQuote" it gives me error that:
$1 referential integrity violation - key referenced from deal not found in quote.
Any ideas?
Thanks,
Denna
Cris Daniluk <cris.danilu..mail.com> wrote:
There's absolutely no reason why you can't do this - just create the
second relationship in the DbEntity, but be sure to select the right
fields to connect the tables.
On Apr 5, 2005 12:04 PM, Dhruti Ramani wrote:
> Hello All,
> I am Denna Ramani. I am getting familiar with Cayenne. I really like this
> software.
>
> We are using postgresql database right now.In one of our project, we need
> two relations between same two tables. For example, we have "Deal" and
> "Quote" objects. And relations are, "Deal" can have many "Quotes" but "Deal"
> has one"AcceptedQuote". "AcceptedQuote" is one of from many
> Quotes that Deal has. Do you have any idea about how one can do this?
>
> Thanks,
> Denna
>
> ________________________________
> Yahoo! Messenger
> Show us what our next emoticon should look like. Join the fun.
>
>
---------------------------------
Do you Yahoo!?
Better first dates. More second dates. Yahoo! Personals
This archive was generated by hypermail 2.0.0 : Tue Apr 05 2005 - 12:40:24 EDT