Devart Forums

Posted: **Thu 19 Apr 2007 17:43**

My application was migrated from BDE with your Migration wizzard.

Some o my queries are like this:

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

Posted: **Fri 20 Apr 2007 08:50**

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

Posted: **Fri 20 Apr 2007 11:41**

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

Posted: **Fri 20 Apr 2007 12:57**

Thanks.

The next build will have a lot of fixes

Posted: **Mon 23 Apr 2007 13:51**

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

When the next build will be out?

Posted: **Mon 23 Apr 2007 14:31**

New ODAC build is already released.

Devart Forums

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

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

When the next Build will be out????