Subject | TIBOTable, Filtered, and RecordCount |
---|---|
Author | Joe Martinez |
Post date | 2002-09-19T21:13:21Z |
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 the
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
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 the
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