Subject Re: [IBO] TIBOTable, Filtered, and RecordCount
Author Jason Wharton
RecordCount is only accurate when using OnFilterRecord if all records are in
the buffer. Call FetchAll prior to accessing RecordCount to make sure it is

Jason Wharton
CPS - Mesa AZ

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Joe Martinez" <joe@...>
To: "IB Objects" <>
Sent: Thursday, September 19, 2002 2:13 PM
Subject: [IBO] TIBOTable, Filtered, and RecordCount

> I have a TIBOTable object that is filtered. At the start of my app, I
> examine the RecordCount property of the table and use it to update a label
> on the screen. I also re-examine it in the OnDataChange event and update
> the label as well.
> At the beginning of my app, I examine the RecordCount property, and the
> count includes ALL records in the table, NOT just the ones that pass the
> filter (determined by the OnFilterRecord event). Later on, after the app
> is underway, the RecordCount DOES report the correct number of (filtered)
> records, so there's obviously a timing issue here.
> It's like at the beginning of my app (I've tried putting the code in the
> main form's OnShow event handler, as well as the table's AfterOpen event
> handler), the records aren't being filtered yet, so it incorrectly gets
> unfiltered count.
> When does the filter get put into effect, so that RecordCount shows the
> correct number of records?
> Where can I put my code (to be run at program start up) so that Record
> Cound will report the correct number of FILTERED records?
> Thanks,
> Joe