Bug with detail parameters that are used more than once
Posted: Fri 22 Nov 2013 20:42
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?
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?