Re: Frontbase [Solved]
Re: Frontbase [Solved]
- Subject: Re: Frontbase [Solved]
- From: Chuck Hill <email@hidden>
- Date: Tue, 3 Oct 2006 13:02:11 -0700
On Oct 3, 2006, at 12:28 PM, RedBugz Software wrote:
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.
Can you make the code for this available?
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/practical_webobjects
_______________________________________________
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