On Oct 3, 2006, at 12:28 PM, RedBugz Software wrote:

On 10/3/06, John Huss <[EMAIL PROTECTED]> 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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to