Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

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

rbuserrbuser
edited July 2010 in End User
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

Comments

  • rbuserrbuser
    edited July 2010
    By the way I'm using Delphi 7 and RB 10

    "Alejandro Romero Parra" escribi? en el mensaje
  • nardmoseleynardmoseley
    edited July 2010

    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


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited July 2010
    thanks Nard

    "Alejandro Romero Parra" escribi? en el mensaje
This discussion has been closed.