Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 IBX DataSet's RecordCount property returns an inaccurate value.


When working with any IBX dataset component, why doesn't RecordCount return then number of records in my table on the server?   

    The BDE called FetchAll before calling RecordCount, IBX datasets do not. Call TDataSet.FetchAll before using TDataSet.RecordCount. FetchAll actually downloads all the records locally and counts them, for large tables and result sets, this can be undesirable. A faster, server side way, of accomplishing the same task is to use two select statements:

      IBQuery .SQL.Clear;   IBQuery .SQL.Add('select count(ANYFIELD) FROM YOURTABLE');   IBQuery .Open;

    You can access the RecordCount by   IBQuery .FieldByName('COUNT').AsInteger;  



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use