SQL result from Reporting solution not: FULL LEFT or RIGHT OUTER join tables, but QueryDesigner FORM

rbuser

Hi

I'm using your excellent reporting solution in a Delphi project, but right
now I have an issue.

If I invoke the reporting solution and define a query with two tables at
least using the integrated querydesigner the SQL result are not join the
tables except for the INNER join. This mean that FULL,LEFT or RIGHT OUTER
joins are not in the SQL sentence even If I choose that kind of join in the
tables (first separator of the querydesigner).

I coded a simple form in the same project calling the querydesigner via code
and in this scenario the SQL result WORKS excellent.

Can you point me in the right direction please?

Best regards

rbuser

By the way I'm using Delphi 7 and RB 10

"Alejandro Romero Parra" escribi? en el mensaje

nardmoseley

Try checking the Designer.DataSettings.SesisonType, SQLType, DatabaseType
etc. This influences the sql syntax that is generated.

At Delphi design-time, the Designer.DataSettings are loaded from
RBuilder.ini. You can modify them via the Data workspace of the designer,
select the File | DataSettings menu option.

At run-time, configure the TppDesigner.DataSettings properties.



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

thanks Nard

"Alejandro Romero Parra" escribi? en el mensaje