RecordCount and Filtered

Hello,

I am using ADO in Delphi 5 and Delphi 2006 VCL.NET.
DataBase is Access.

In TADODataSet:
CursorLocation=clUseServer.
CommandType=CmdTableDirect
Filtered=true

In the DataChange-event of the connected TDataSource I want to get the
recordcount:
No:=Table.RecordCount

but it always shows the unfiltered count.
Is that a normal behaviour and how can I get the filtered count?

Thanks+regards

Simon


.

Relevant Pages

  • Re: How do I capture Delphi 5 TADODataset timeout error consistently?
    ... When I run a query that executes a stored procedure, ... If I just run straight SQL text that returns a large dataset, ... > I am using Delphi 5, hitting a SQL Server 2000 database. ... > I have a simple reporting application that uses a TADODataset to run ...
    (borland.public.delphi.database.ado)
  • ClientDataset with TADODataSet
    ... Delphi 7. ... "Cannot create new connection in manual or distributed transaction ... i had an ADOConnection and a TAdoDataset with Cursor location on ...
    (borland.public.delphi.database.ado)
  • Updating with TADODataSet
    ... I am converting from Paradox in Delphi 6 to Microsoft SQL. ... TADODataSet to get a subset of data for a grid, ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery vs. ADODataSet
    ... > TADODataSet directly in Delphi, maybe because I was a BDE user. ... > What is the positive side of using TADODataSets instead of TADOQueries?. ... "'Serious' ADO Speed Techniques With Delphi - Part 1" ...
    (borland.public.delphi.database.ado)
  • Re: CommandTimeout - TDataSetProvider/TADOQuery
    ... No you will have to update your version of Delphi to get that fixed. ... TADODataset is a better component to use than TadoQuery ... Brian Bushay ...
    (borland.public.delphi.database.ado)