How do you accomplish a left outer join in the end-user tool?

rbuser

In the End User tool (RB 6.03) I can specify Left Outer join in either the
Query Wizard or the Query Designer, but the SQL generated always does an
inner join.

What's the trick?

Kevin

digitalmetaphors

The SQL should reflect the join you specify. What is the SQL type you have
chosen? LocalSQL, SLQ1 or SQL2? Try setting it to SQL2. Do you have a WHERE
clause that performs the join instead ie. you have selected SQL1? Can you
reproduce this using our BDE Paradox Report Explorer demo at runtime? This
should work in RB 6.03, but can you recreate the problem using RB 7.02
trial.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

SQL2 did it.

Thanks,

Kevin