Bug with detail parameters that are used more than once

[heidenbluth]

Unfortunately, ODAC 9.1.4 introduced a bug with parameter handling in queries.
Lets consider two TOraQuery components that are linked in a master/detail relationship.

The master query contains a query like

SELECT MASTER_ID, ...
FROM TAB0

The detail query references the master query using the same :parameter name twice, e.g.

SELECT ...
FROM TAB1
WHERE TAB1.MASTER_ID = :MASTER_ID
UNION
SELECT ...
FROM TAB2
WHERE TAB2.MASTER_ID = :MASTER_ID

This works fine initially. But when the master query scrolls, i.e. executes "Next", the detail query does not show data any more. When you re-open the detail, it shows data again.

In prior versions this worked fine.
Can you provide us with a fix for that, please?

[AlexP]

hello,

We cannot reproduce the described problem. Please provide a small sample demonstrating the problem to alexp*devart*com, including the table creation scripts. In addition, please specify the used IDE version.