Filter not working with last update 5.80.0.41

AlexandreECAD · Post by **AlexandreECAD** » Tue 03 Apr 2007 13:02

I use Filter in some querys and after updating to version 41 all my filters stop working.

I'm using BDS 2006 and ODAC Net Option.

When I went back to version 40 all worked fine.

Challenger · Post by **Challenger** » Tue 03 Apr 2007 14:54

Please describe the situation more detailed.

AlexandreECAD · Post by **AlexandreECAD** » Tue 03 Apr 2007 19:55

Insert the following code before the OraQuery.open line in the CRGrid Example that comes with ODAC in the Click event of Open button and change the OraSession to Net = True and the query to NonBlocking = True;

Code: Select all

  OraQuery.Filter := 'CITY = ' + QuotedStr('LION');
  OraQuery.Filtered := True;

It doesnt work.

My Oracle version is 8.1.7

Plash · Post by **Plash** » Wed 04 Apr 2007 13:00

Please specify what the problem is: no records are returned or all records are returned.

AlexandreECAD · Post by **AlexandreECAD** » Wed 04 Apr 2007 13:21

No records are returned.

Plash · Post by **Plash** » Wed 04 Apr 2007 13:39

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

AlexandreECAD · Post by **AlexandreECAD** » Wed 04 Apr 2007 14:00

Thanks. In a couple of days?

Plash · Post by **Plash** » Wed 04 Apr 2007 14:52

We are planning to release the new build of ODAC 6 with the fix for this bug in a couple of days. If you need a build of ODAC 5 with the fix, please contact us by e-mail odac*crlab*com and specify your licence number, ODAC edition and Delphi version.

AlexandreECAD · Post by **AlexandreECAD** » Wed 04 Apr 2007 16:42

I've sent an e-mail requesting the ODAC 5 build.

Thanks for the fast feedback.