Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

WHERE clause using Parameterized SQL Linking

edited June 2012 in DADE
Hi,

Using Delphi 6, RB 11.08.

I have a report that contain 2 pipelines, the second of which contains
manually edited SQL. The 2 pipelines are linked, using Parameterized linking
(because this is the default when one of the pipelines is manually edited).
The report works fine.

I notice that viewing the SQL in the Link|SQL window, it adds the parameter
in a WHERE clause:

SELECT Table.Field
FROM Table
WHERE (Field2 = :Field2) // added by RB
ORDER BY Field1

If I then add my own WHERE clause to the query, it can't handle it. RB still
adds its parameter as a WHERE, instead of an AND:

SELECT Table.Field
FROM Table
WHERE (Field3 = 'Some Value') // my WHERE clause
WHERE (Field2 = :Field2) // added by RB
ORDER BY Field1

Is this a known limitation, or a bug, or am I doing something wrong?

Thanks,
Jason.

Comments

  • edited June 2012

    This is a limitation - I added this to the list of requested enhancements.

    One alternative is to use the manual rather than the parameterized SQL
    option.


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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2012
    Thank you Nard,

    Jason.

This discussion has been closed.