Problem with more than one parameter with the same name in query

[AlexandreECAD]

My application was migrated from BDE with your Migration wizzard.

Some o my queries are like this:

Code: Select all

SELECT T1.COD, T1.DESC
  FROM TABLE1 T1
WHERE T1.COD = :COD1
    AND T1.DESC IN (SELECT T2.DESC
                                 FROM TABLE2 T2
                                WHERE T2.COD = :COD1)

I had the COD parameter 2 times in the component's parameters list.

This kind of query wasnt working after my update to ODAC 6.0.0.5

Executing my app with DBMonitor only one parameters received the value the other keep

If I delete the query and insert it again in the component, now I have only one COD parameter and the query works perfect.

I think that this is a bug because was working before, but I also know that I dont need to have two or more parameters in the component with the same name, but I'll have to change a lot of programs.

I hope you can help me.

Alexandre

[Plash]

We have fixed this problem. The fix will be included in the next build of ODAC.

[robert.wachtel]

Ran into the same problem. Hopefully the new build comes out quick...

[AlexandreECAD]

Thanks.

The next build will have a lot of fixes

[AlexandreECAD]

Man I got to go back to 5.80.41 (with filter fix you sent me).

When the next build will be out?

[Plash]

New ODAC build is already released.