Filtered for MSAccess

Greetings all !

I have one problem regarding Delphi 6 and MS Acces.
Here are some detailed steps I have gone through:
1. Delphi is Delphi 6, MS Access is MS Access 2000.

2. I am using ADODB component kit, not the BDE.

3. Connection works fine.

4. Here's how my connection works:
  TADOConnection <-> TADOTable <-> TDataSource

5. Tried sorting ASC & DESC using the TADOTable.Sort. Works.

6. Tried using the Filter property:
  aTable.Filtered := false;
  aTable.Filter := <some filter>;
  aTable.Filtered := true;
    Works.

7. However, if I tried to supply some sets of Filter options like 
this:
  tblProduct.FilterOptions := [foCaseInsensitive];
  -or-:
  tblProduct.FilterOptions := [foNoPartialCompare];
    It does not work, saying that such filter options are not 
supported.

8. What I am trying to achieve is: to be able to filter the table 
for a certain string contained within a field (without using any 
TADOQuery).

9. If there is a way to filter for a certain string without any 
TADOQuery, I would be glad... ;) However, I can also live with 
TADOQuery. 'Coz the reason behind all this TADOQuery-avoidance is, I 
intend to use the filter in conjunction with TADOTable.Sort.

Thank you very much for your kind attention.




------------------------ Yahoo! Groups Sponsor ---------------------~-->
Free shipping on all inkjet cartridge & refill kit orders to US & Canada. Low prices up to 80% off. We have your brand: HP, Epson, Lexmark & more.
http://www.c1tracking.com/l.asp?cid=5510
http://us.click.yahoo.com/GHXcIA/n.WGAA/ySSFAA/i7folB/TM
---------------------------------------------------------------------~->

CodeCoffer - new Delphi code protection Tool!
http://www.delphicollection.com/public/CodeCoffer.htm
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/