efficient way to get number of total (unfiltered) records in dataset

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ludek
Posts: 296
Joined: Thu 12 Oct 2006 09:34

efficient way to get number of total (unfiltered) records in dataset

Post by Ludek » Fri 26 Sep 2014 08:10

hi,
I'm looking for a way to efficiantly get number of fetched records of a filtered tmsquery. Is there something better than temporarily set query.filtered := false, get query.recordcount and reset the query.filtered to true?
Thanks, Ludek.

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: efficient way to get number of total (unfiltered) records in dataset

Post by azyk » Mon 29 Sep 2014 13:32

Currently, SDAC doesn't support the capability to retrieve the full amount of records contained in the dataset when filter is enabled.

Post Reply