WHERE clause using Parameterized SQL Linking

rbuser

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.

nardmoseley

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

rbuser

Thank you Nard,

Jason.