Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Error in docs regarding useAnsiJoins?

    Hello Isomorphic,

    please see this javadoc: http://www.smartclient.com/smartgwte...l#useAnsiJoins.

    It says "Note, outer joins (see joinType) only work with certain database products if you choose *not* to use ANSI joins".

    From my understanding it is easy to simulate an inner join with a cross join plus additional where clauses. This is not true for outer joins. So in my opinion the "not" in the sentence does not belong there.

    Besides that, could you advise if SmartGWT-Outer Joins work with Oracle 11.2?

    Best regards,
    Blama

    #2
    Just realized that I misinterpreted the sentence.

    It means:
    !useAnsiJoins => only some DBs (e.g. += in Oracle)

    It does NOT mean (as I understood before):
    useAnsiJoins => outer join will work for some DBs.

    And Outer Joins work with Oracle 11.2.

    Comment

    Working...
    X