Re: Re: Frontbase [Solved]
Re: Re: Frontbase [Solved]
- Subject: Re: Re: Frontbase [Solved]
- From: "RedBugz Software" <email@hidden>
- Date: Tue, 3 Oct 2006 13:28:39 -0600
On 10/3/06, John Huss <email@hidden> wrote:
> Another option, and one that I have not tried, is to change the join
> type for this relationship from inner to a left outer join.
>
> Chuck
Frontbase does NOT handle legacy style outer joins correctly (key *=
key). It will return a result set, but it will be wrong. This has
always frustrated me.
John
DB2 has the same problem and I had to write a custom JDBC plugin to switch the format to the LEFT OUTER JOIN syntax instead.
Logan
_______________________________________________
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