• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Outer Joins?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Outer Joins?


  • Subject: Outer Joins?
  • From: David Avendasora <email@hidden>
  • Date: Wed, 17 Dec 2008 11:16:26 -0500

Hi all,

Before I start: yes Chuck, I've googled, searched documentation, etc aboot this. :-P

I have a to-one relationship in which the destination object may or may not actually exist. The destination object may get deleted out of the database without EOF's knowledge. The FK values are still in the original table, but the record in the destination table is gone. The destination table is in a Microsoft (Great Plains) Dynamics database.

This causes an ObjectNotAvailableException to be thown. What I'd like the relationship to return is null.

Isn't this what an Outer Join is supposed to do?

The problem is that I can't select Outer Join for the relationship in Entity Modeler. The drop-down is grayed-out.

1) Is this the correct use of an Outer Join
2) Why can't I set it?

Dave


_______________________________________________ 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
  • Follow-Ups:
    • Re: Outer Joins?
      • From: Mike Schrag <email@hidden>
    • Re: Outer Joins?
      • From: Chuck Hill <email@hidden>
  • Prev by Date: Re: Can not get objectForGlobalID
  • Next by Date: [ANN] WOGWT framework for integrating GWT with WebObjects
  • Previous by thread: Re: Is dynamic element action method order deterministic?
  • Next by thread: Re: Outer Joins?
  • Index(es):
    • Date
    • Thread