Re: Database Filter question

Thank you, that was what I thought - it was great to have it confirmed.

Allan


"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:8a6081p94hh06i42aqhaiotf9c7vpesqgs@xxxxxxxxxx
>
> >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 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: ADO find Date
    ... I'll play with the filter. ... > According to the ADO help file ... ... > GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.modulesdaovba)
  • Re: Heavy Mail Merge Application
    ... Word requires at least one data record in order to provide a list of ... What I generally tend to do is use ADO (or whatever connection method is most ... Then repeat the read, filter and merge. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Sorting data to last 30 days
    ... I think you should explore applying the filter to the SQL database so that ... There are problems with trying to use AutoFilter here: custom criteria don't ... filter criteria. ...
    (microsoft.public.excel.misc)
  • ADO Find Help?
    ... I'm using VB6, and an SQL database. ... ..Filter to do this, and believe I have it correct. ... The result of this is that when valueB changes, ... records that contain valueA. ...
    (microsoft.public.data.ado)