Database Filter question
- From: "Allan Nielsen" <ace-allan@xxxxxxxxxxxxxx>
- Date: Mon, 9 May 2005 09:47:43 +0200
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
.
- Follow-Ups:
- Re: Database Filter question
- From: Brian Bushay TeamB
- Re: Database Filter question
- From: Yannis
- Re: Database Filter question
- Prev by Date: Re: Field names for columns from more than one table
- Next by Date: Re: Database Filter question
- Previous by thread: Field names for columns from more than one table
- Next by thread: Re: Database Filter question
- Index(es):
Relevant Pages
|
