Re: TADODataset.Filter?


Sven Pran wrote:
2: Is there a typo in your text below? Shouldn't the parameter to
QuotedStr be (edit1.Text + '*') ?

Not really, I have done this on purpose - for flexibility during testing, I type the wildcard(s) within the TEdit box (so they are included in "edit1.Text").

3: I noticed that you seemed to use the Filter and Filtered
properties either or both in TADODataset and in TADOQuery.

I see no need to involve TADOQuery so all my filtering attempts
are done on my TADODataset component. Do you know if there
could be any trap here? (I have TADOConnection, TADODataset,
TDataSource and TDBGrid all linked together and working
as expected except for my difficulties with local filtering).

Yes, I have used TADOQuery, TADOTable, TADODataset interchangeably in my tests. They all behaved correctly. Unfortunately, I am not aware of any "traps" you should avoid when using TADOdataset.
By the way, have you tried using TADOTable instead of TADODataset?

Bill Dekleris.

-----------------------------------------------------------------------------------------


http://www.infosnap.eu

InfoSnap · the powerful, all-purpose information and knowledge-base manager.

----------------------------------------------------------------------------------------- .

Relevant Pages

  • Re: ADOQuery or ADOTable?
    ... TADOQuery is ok for querys, but as TADODataset has all the ... > features, ... As per Delphi Help. ... TADODataSet is not capable of issuing Data Manipulation Language SQL ...
    (borland.public.delphi.database.ado)
  • Re: TADODataset.Filter?
    ... properties either or both in TADODataset and in TADOQuery. ... I see no need to involve TADOQuery so all my filtering attempts ... could be any trap here? ...
    (borland.public.delphi.database.ado)
  • Re: slow refresh of mysql datasets via ADO
    ... the nasty habit to try to load the whole table data. ... TADODataset instead. ... I already got rid of the table. ...
    (borland.public.delphi.database.ado)
  • Re: Changing DB with TADOConnection
    ... >to the new DB and can even oepn up a TADOQuery and manipulate it. ... >However, when I then go to open a TADODataset, I get either a "stack ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery or ADOTable?
    ... a TADOQuery must be used for DML. ... > TADODataSet is not capable of issuing Data Manipulation Language ... > (DML) SQL statements that do not return result sets (like DELETE, ... could be seen as personal POV. ...
    (borland.public.delphi.database.ado)