WHERE clause using Parameterized SQL Linking
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.
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.
This discussion has been closed.
Comments
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
Jason.