Page 1 of 1
Howto get accurate TIBCQuery.RecordCount when Filtered=True?
Posted: Wed 23 Sep 2009 20:31
by jcrouch
Hi, I have applied a Filter 'active_state=1' and turned Filter on. When I access the RecordCount property, the value returned is the count of all records (i.e. non filtered). How can I get the equivalent of the Filtered Record Count?
Thanks
Posted: Thu 24 Sep 2009 07:34
by Plash
The RecordCount property returns the correct record count in the following cases:
a) the QueryRecCount option is set to False;
b) if QueryRecCount = True, you will get the correct value after all records will be fetched.
Posted: Mon 28 Sep 2009 21:37
by jcrouch
Hi again,
I appreciate your answer, however I don't believe you understood my question. The RecordCount property IS NOT RETURNING THE CORRECT RECORD COUNT WHEN A FILTER IS APPLIED.
For kicks I have made sure QueryRecCount was set to False (it is)... but this really should have nothing to do with the issue.
I don't know how to repeat this question any different or I would for clarification... "How can I get the equivalent of the Filtered Record Count?"
Posted: Tue 29 Sep 2009 07:47
by Plash
If QueryRecCount = False, the RecordCount property returns the count of records that match the filter. We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.