🚀 go-pugleaf

Our product is switching from a Paradox via BDE application to a SQL-Server (or MSDE) via ADO Express.  One major minor problem that we had was with the record count (RecordCount property of the TADODataset) after a filter.  I am using Woll2Woll's TwwDBGrid component to view a list of records, select and then drill down into a data entry/modification form.  After applying a filter to the dataset the RecordCount property would always show the incorrect number.  It would contain the number of total records in the dataset before filtering while the grid showed only those that were allowed through the filter.

After having some of my team look into taking the filter and applying it to a where clause and issuing a "SELECT COUNT(*) FROM..." SQL statement we again bumped our heads when we wanted to filter on a lookup or calculated field.

The easiest and preliminarily fast solution was to do the following...

//Where G is the instance of TwwDBGrid...
//Note G may have to have MultiSelect enabled.
int ResultCount;
G->SelectAll();
ResultCount = G->SelectedList->Count();
G->UnselectAll();
//ResultCount contains the count.

I hope this saves a few people some time.