Re: Database Filter question

Allan Nielsen wrote:

> Hello,
>
> 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?
>
> Question 2:
>
> ------------------------------------------------------
> number_before := ADODataSet1.RecordCount;
> ADODataset1.Filter := 'address = ' +
> ADODataset2.FieldByName('addr').AsString;
> ADODataset1.Filtered := true;
> number_after := ADODataset1.RecordCount;
> -------------------------------------------------------
>
> Assuming that this actually filters out some records, the
> number_before and number_after shouldn't be the same, right? Or does
> it need a refresh somewhere?
>
> Delphi 2005, SQL Server 2K, btw.
>
> TIA
>
> Allan

You are in the correct path You need to take in to account that the
value needs to quoted, Change Filter property to the following

ADODataset1.Filter := 'address = ' +
QuotedStr(ADODataset2.FieldByName('addr').AsString);

then test it again.

Regards
Yannis.
.

Relevant Pages

  • 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)
  • Re: Database Filter question
    ... > Allan Nielsen wrote: ... >> I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... >> will it automatically Execute its CommandText and then filter the new ...
    (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: ADO Find Help?
    ... Once the single record is found, ... > 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, ...
    (microsoft.public.data.ado)