Page 1 of 1
Filter not working with last update 5.80.0.41
Posted: Tue 03 Apr 2007 13:02
by AlexandreECAD
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.
Posted: Tue 03 Apr 2007 14:54
by Challenger
Please describe the situation more detailed.
Posted: Tue 03 Apr 2007 19:55
by AlexandreECAD
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
Posted: Wed 04 Apr 2007 13:00
by Plash
Please specify what the problem is: no records are returned or all records are returned.
Posted: Wed 04 Apr 2007 13:21
by AlexandreECAD
No records are returned.
Posted: Wed 04 Apr 2007 13:39
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.
Posted: Wed 04 Apr 2007 14:00
by AlexandreECAD
Thanks. In a couple of days?
Posted: Wed 04 Apr 2007 14:52
by Plash
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.
Posted: Wed 04 Apr 2007 16:42
by AlexandreECAD
I've sent an e-mail requesting the ODAC 5 build.
Thanks for the fast feedback.