Re: Database Filter question


>I use ADO to connect to an SQL Database. I use an ADODataSet to hold a
>complete recordset from a select query.
>
>Question 1:
>When I set the Filtered property to True (ADODataset1.Filtered := true),
>will the dataset filter the current records that it holds, or will it
>automatically Execute its CommandText and then filter the new resultset? Or
>how does the Filter exactly work?
The filter is applied to the in memory
records selected by an execration of the commandText

>

--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Database Filter question
    ... >>I use ADO to connect to an SQL Database. ... >>automatically Execute its CommandText and then filter the new resultset? ...
    (borland.public.delphi.database.ado)
  • Database Filter question
    ... I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... complete recordset from a select query. ... automatically Execute its CommandText and then filter the new resultset? ...
    (borland.public.delphi.database.ado)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... in the criteria cell in the graphical query builder. ... use as the source in the routine. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ...
    (microsoft.public.access.formscoding)
  • Re: Help with Microsoft help on linking Access to Outlook
    ... and have the query point to the combo box to get its value. ... the same filtered recordset every time. ... choose themselves what fields to filter on. ... Set MyRS = MyDB.OpenRecordset" ...
    (microsoft.public.access.formscoding)
  • Re: Filtering Via Form, and then Export
    ... I just converted they query ... the detail rows were bound to, to a make table action query, and have indexes ... But the filter form works ... Select MonthYear of Data to Export: <dropdown choices> ...
    (microsoft.public.access.queries)