Re: TADODataset.Filter?


"Bill Dekleris" <quasar@xxxxxx> wrote in message
news:453b6391@xxxxxxxxxxxxxxxxxxxxxxxxx

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").

Fair deal! I did wonder but actually did my own tests the same way.


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?

Yes I have tried TADOTable too (with the same problem). But as I do
not want all fields retrieved TADOTable is not really much useful for me.

regards Sven


.

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)