Re: TADODataset.Filter?

From: "Bill Todd" <no@xxxxxx>
Date: 20 Oct 2006 14:34:44 -0700

The fact that you want to filter the dataset suggests that there are a
lot of records. If so, why do you want to retrieve all of them
initially? Users never want to look through more than 100 records
manually.

There is no reason not to use the WHERE clause to select the records
you want.

--
Bill Todd (TeamB)
.

Follow-Ups:
- Re: TADODataset.Filter?
  - From: Sven Pran

References:
- TADODataset.Filter?
  - From: Sven Pran

Prev by Date: Re: Is this correct? (TADOConnection)
Next by Date: Re: Add field to ADOTable and a Column for a tDbGrid at runtime
Previous by thread: TADODataset.Filter?
Next by thread: Re: TADODataset.Filter?
Index(es):
- Date
- Thread

Relevant Pages

Re: TADODataset.Filter?
... set into local memory, then a filter may be faster. ... Bill Todd (TeamB) ...
(borland.public.delphi.database.ado)
Re: TADODataset.Filter?
... then a filter may be faster. ... Bill Todd (TeamB) ... I have made some tests (and documentation searches) ...
(borland.public.delphi.database.ado)
Re: Master / details
... Yes, however, I would not use a filter. ... parameterized SELECT to get the statistics you need. ... Bill Todd ... TeamB cannot answer questions received via email ...
(borland.public.delphi.database.ado)
Re: list all groups
... to filter on group objects instead of user objects. ... I retrieve and output ... Dim objCommand, objConnection, strBase, strFilter, strAttributes ... ' Filter on group objects. ...
(microsoft.public.scripting.vbscript)
Re: list all groups
... to filter on group objects instead of user objects. ... I retrieve and output ... Dim objCommand, objConnection, strBase, strFilter, strAttributes ... ' Filter on group objects. ...
(microsoft.public.scripting.vbscript)